Find unique record
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...
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...
"Isabelle" wrote:
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
|