Unique records excel

[mikerobe]

Hi,
I have a sheet where there are unique ID numbers in column B. However
multiple rows of data may be present on the sheet with this unique ID,
all in column B (So not really unique). There will be a few rows on
the sheet where these numbers are genuinely unique. I wish to delete
all rows and leave these genuinely unique records behind. Is this
possible.


Thanks
Eddie

 

[Gord Dibben]

Select column B.

Data>Filter>Advanced Filter

Checkmark "unique recoreds only" and "copy to another location".

If you want to copy to another sheet see Debra Dalgleish's site for
instructions.

http://www.contextures.on.ca/xladvfilter01.html#ExtractWs


Gord Dibben MS Excel MVP

 

[mikerobe]

Select column B.

Data>Filter>Advanced Filter

Checkmark "unique recoreds only" and "copy to another location".

If you want to copy to another sheet see Debra Dalgleish's site for
instructions.

http://www.contextures.on.ca/xladvfilter01.html#ExtractWs

Gord Dibben  MS Excel MVP






- Show quoted text -

Thanks Gord
I have tried this but I get one copy of all the ID's when the filter
is applied. I only want the ID in the column where there is only one
record as follows

Head1 Head2
John 123
Steve 121
Will 123
Kate 122
Pete 122

When the filter is applied I only want

Head1 Head2
Steve 121


The record 121 being the unique ID.

I hope this is clear

Thanks
Eddie