Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
One way to do it without macros would be via pivot tables.
To do that, highlight the identifier columns in each of the sheets - hold control while moving between sheets and clicking on the various columns to allow non-contiguous data selection. Once all columns are highlighted (and this assumes no header row, or if there is a header row has the same heading), use the Data, Pivot Table option to create a new pivot table. Select the data column for both the "Row" section and also the "Data" section, setting the data section to count, descending (double-click on it - count is default, and set options to sort descending by count). This will result in a pivot table with the identifiers that appear most frequently at the top (with the resulting number of times that they appear). Therefore, if any appear more than once, they will be listed at the top. Hope that helps. "ChristyL" wrote: I have several sheets in an excel document. Each sheet has a column for a unique identifer. I need to be able to look through all the sheets to determine if there are any duplicates. Is there an easy way to do this? Possibly with a macro. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete duplicate and original entries in excel | Excel Discussion (Misc queries) | |||
search/delete duplicate entries in excel '02? | Excel Worksheet Functions | |||
How do I delete duplicate entries in excel? | New Users to Excel | |||
find duplicate entries and delete them? | Excel Worksheet Functions | |||
How do I delete duplicate entries? | Excel Worksheet Functions |