Listing names automatically

Hey there,

Thank you for the wonderful forum.

Can someone help me with how to make a list as shown in the attachment?

Each new name that's entered in the row 'B' needs to be added to the list in row 'D' automatically.

Please help me with this.

Thanks & Regards

Vinod

TEST.JPG

If I am not mistaken you want to display unique values from list.
Put into D2:

Formula:

Please Login or Register  to view this content.

accept with Ctrl+Shift+Enter (array formula) and drag it down as long as needed.
Also expand range (B2:B200) if you need to.

And this can also be achieved with an ordinarty formula. No need for array entry with this one:

IFERROR(INDEX($B$2:$B$200,MATCH(0,INDEX(COUNTIF($D$1:$D1,$B$2:$A$200),0),0)),"")

Originally Posted by Glenn Kennedy

IFERROR(INDEX($B$2:$B$200,MATCH(0,INDEX(COUNTIF($D$1:$D1,$B$2:$A$200),0),0)),"")

Little mistake slipped there (red), I believe it's $B$200.

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.