Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find unique record
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find unique record
.. 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 --- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find unique record
Try Advanced Filtering, it has a Unique Filter option:
Data === Filter === Advanced Filter Select "Unique records only" option. HTH, John "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to find and record Unique values? | Excel Discussion (Misc queries) | |||
Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
EXTRACTING UNIQUE RECORD BASED ON CONDITION | Excel Worksheet Functions | |||
Using a listbox to show every unique record in a range | Excel Worksheet Functions | |||
Display unique record | Excel Discussion (Misc queries) |