Find unique record

  • Thread starter Thread starter Isabelle
  • Start date Start date
I

Isabelle

Hi, i have a list of 30 over thousand data. There is a column with
duplicates, how can i identify only the unique record.

Regards
 
Assuming Col A contains the values to check for duplicates...
enter this in the first blank column
=COUNTIF(A1:A$2000,A1) and copy down till A2000
(change 2000 to the last row number in your data set and copy down till that
cell)
Unique records will have 1 as the value in the column with this formula...
You can filter on Not equal to 1 and delete...
 
.. i have a list of 30 over thousand data. There is a column with
duplicates, how can i identify only the unique record.
Click to expand...

One fast n easy way is to create a simple pivot. Assuming the col label is
Vendor, in step 3 of the wiz., click Layout, then drag n drop Vendor into
both the ROW and DATA areas. Click OK > Finish. Done! Hop over to the pivot
sheet for the desired results: the required uniques list in the 1st col, with
corresponding counts in the 2nd.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---
 
Try Advanced Filtering, it has a Unique Filter option:

Data ===> Filter ===> Advanced Filter
Select "Unique records only" option.

HTH,
John
 
Back
Top