Unique records 1

[CCNProjects]

Hello all.

I have a column with multiple identical records.
I would like to create a column with unique records.
Example:
from
col1 to col2
A A
A B
B c
C
B
Thanks for any hint.

 

[AnotherHiggins]

Data > Filter > Advanced Filter

Copy to another location

List Range = $A:$A
Criteria Raange = <[gray]leave blank[/gray]>
Copy To = $B$1

Tic box beside Unique Values Only

OK

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[CCNProjects]

Thanks