Is anyone out there clever enough to come up with a formula to put in the cells D1:D9 that gives me the unique list of names listed in column F.
I know I could copy/paste the full list (column A) and then remove duplicates but that doesn't really suit what i am wanting to do and instead i'd like some formula D1:D9 instead.
Any ideas?
I thought I had cracked it with =INDEX($A$1:$A$75,MATCH(C1,$B$1:$B$75,0),1) but I soon realised a name duplicated when it came up for a second time.
Bookmarks