Hi All

I'm using this formula to extract and list unique values from column F

=IF(COUNTIF(F$3:F3,F3)=1,F3,"")

It does the job , and lists the first occurrence of each item. Unfortunately it leaves blank cells where there is a repetition of the item.

So instead of

Susan
John
Harry
Joanne
Billy

It gives

Susan

John
Harry

Joanne
Billy

Where Susan and Harry are repeated.

Can someone think of a way to avoid the blank cells? Or some other (better!) way of making a unique list form the entries in column F? Maybe some VBA under the workbook tab? If it were able to be sorted alphabetically too that would be a real bonus.

Grateful for any help.


Very Best Wishes ,