List rows if item in one column is unique

[Jan Kronsell]

I have a list like this (two columns)

A B
1 John
2 Brian
3 Benny
4 John
5 Bill
6 Jonathan
7 Brian
8 Edward
....

Somewhere else in the sheet, I like a listing of rows, but only each name
from column B once like

D E
1 John
2 Brian
3 Benny
5 Bill
6 Jonathan
8 Edward

Can this be done, using only spreadsheet functions or do I have to use a VBA
solution?

I have tried using the "Unique only" in ther Advanced Filter, but if I have
both columns in the Filter Range, the rows are not unique, and if I leave
out column A, it only copies the unuique rows from column B, not the numbers
from column A.

Jan

 

[Gord Dibben]

Select Column B

Data>Filter>Advanced filter.

Filter in place. Unique records only>Ok

Now just select the filter results and copy.

Paste where you wish.


Gord Dibben MS Excel MVP

 

[Jan Kronsell]

Thanks.

Jan

Select Column B

Data>Filter>Advanced filter.

Filter in place. Unique records only>Ok

Now just select the filter results and copy.

Paste where you wish.


Gord Dibben MS Excel MVP