Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How Do I find distinct values in a Column
Hello,
I work in the Resourcing Dept. i have to prepare a list of candidates that were interviewed. I have to consolidate lists from four offices. I have come across duplicate candidates entries after consolidating the worksheets. Can anyone tell me how do I find out duplicate values. Thanks |
#2
|
|||
|
|||
I suggest two steps:
1. combine the four lists into a single column and sort by name. This will indicate duplicated items and how many duplicates exist. 2. Insure that there is some kind of label cell at the top of the column. then pull-down Data Filter Advanced Filter... and check unique records only. This will remove the duplicates and leave you with a list of unique names. Update the post if you still have problems. -- Gary''s Student "Stankov" wrote: Hello, I work in the Resourcing Dept. i have to prepare a list of candidates that were interviewed. I have to consolidate lists from four offices. I have come across duplicate candidates entries after consolidating the worksheets. Can anyone tell me how do I find out duplicate values. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
is it possible to Restrict Find & Replace to 1 column | New Users to Excel | |||
search a row to find the column | Excel Worksheet Functions | |||
How sum values in column B using values in column A as the conditi | Excel Worksheet Functions |