Try the following formula, which needs to be confirmed with
CONTROL+SHIFT+ENTER, not just ENTER...

E6, copied down:

=INDEX(D6:D$10,MATCH(0,COUNTIF(E$5:E5,D6:D$10),0))

To trap errors, try the following instead...

=IF(OR(COUNTIF(E$5:E5,D6:D$10)=0),INDEX(D6:D$10,MA TCH(0,COUNTIF(E$5:E5,D6
:D$10),0)),"")

....which also needs to be confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
laurie g wrote:

Need a formula that will list a col of unique names based on multiple entries
of the same in col D. Using Advanced filter does not suit my needs.

Col D col G
5 NAME UNIQUE LIST
6 mmm mmm
7 bbb bbb
8 mmm aaa
9 aaa
10 mmm

Col D has 100 plus entries and is always being edited

Thanks
laurie g