distinct

[vernalGreens]

column A
Name1
Name2
Name3
Name1
Name4
Name5
Name4

I want to get only a single occurence of all the names in column A,
that is, my single occurence column, say column B, should look like

column B
Name1
Name2
Name3
Name4
Name5

 

[Harlan Grove]

(e-mail address removed) wrote...

column A
Name1
Name2
Name3
Name1
Name4
Name5
Name4

I want to get only a single occurence of all the names in column A,
that is, my single occurence column, say column B, should look like

column B
Name1
Name2
Name3
Name4
Name5

If you need to do this infrequently, then you'd be better off inserting
a row above the col A range, entering the same dummy field name in A1
and B1, selecting col A including the dummy field name and using Data >
Filter > Advanced Filter. In the Advanced Filter dialog, select 'copy
to another location', enter B1 in the 'Copy to' field, and check
'Unique records only'.