=IF(ISERR(SMALL(IF(MATCH($A$2:$A$10,$A$2:$A$10,0)= ROW(INDIRECT("1:"&ROWS($A$2:$A$10))),ROW(INDIRECT( "1:"&ROWS($A$2:$A$10)))),ROWS($1:1))),"",INDEX($A$ 2:$A$10,SMALL(IF(MATCH($A$2:$A$10,$A$2:$A$10,0)=RO W(INDIRECT("1:"&ROWS($A$2:$A$10))),ROW(INDIRECT("1 :"&ROWS($A$2:$A$10)))),ROWS($1:1))))

Adjust your range to suit
ctrlshiftenter (not just enter)
Copy all the way down

------------------
mama no teeth



"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