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