Formula to find unique values from a list

Hello friends,

I have a list of Items (Col. B). i had derived an array formula to find out unique values(Col. D) from the list.

what i needed was a formula which will derive unique values from the list and show it in every alternate rows(as sown in Col. F) not in continuous rows.

thanks in advance

andrei461

Please do not PM members regarding threads. This is an open forum were all can participate. In fact we have rule pertaining to this.

Administrative Note:

Welcome to the forum.

Unfortunately, it has come to our attention you have violated Rule #8 of our Forum RULES:

Don't private message, visitor message or email Excel (or Access, Word, etc.) questions to moderators or other members.

All questions and answers will benefit other posters like yourself when discussed in public threads. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.

Breaking this rule is considered harassment by most of our contributors and thus cannot be tolerated. Repeat offense could lead to a permanent ban, so do take this caution to heart.

Post your question in a public thread and our many contributors will come to your assistance, especially if the title is accurate (see Rule #1) and you include a sample desensitized workbook that makes it easy for others to try and help.