distinct

V

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
 
H

Harlan Grove

[email protected] 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
Click to expand...

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'.
 
Top