Find unique record

[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

 

[Sheeloo]

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

 

[Max]

.. i have a list of 30 over thousand data. There is a column with

duplicates, how can i identify only the unique record.

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

 

[JCS]

Try Advanced Filtering, it has a Unique Filter option:

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

HTH,
John