List rows if item in one column is unique

  • Thread starter Thread starter Jan Kronsell
  • Start date Start date
J

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
 
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
 
Thanks.

Jan

Gord said:
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
Click to expand...
 
Back
Top