| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying duplicate recrords from a Data List
Say we have in A1 thru A11:
NAMES james james mike mike david george nigel trevor william albert and we want to see only duplicated names. In B1 enter: TAG In B2 enter: =COUNTIF(A:A,A2) and copy down. We see: NAMES TAG james 2 james 2 mike 2 mike 2 david 1 george 1 nigel 1 trevor 1 william 1 albert 1 Click on B1 and: Data Filter AutoFilter Custom... Is greater than 1 and we now see: NAMES TAG james 2 james 2 mike 2 mike 2 -- Gary''s Student - gsnu200797 "Craig" wrote: Hi, Is there a way for Excel 03 or 07 to quickly scan a data list and display only duplicate records? Thank you! Craig |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying Duplicate Data? | Excel Discussion (Misc queries) | |||
| BUG? : data validation in-cell drop down list is not displaying | Excel Discussion (Misc queries) | |||
| make a list from another list ignoring duplicate entries from orig | Excel Worksheet Functions | |||
| Get rid of empty cells when displaying Data validation list | Excel Discussion (Misc queries) | |||
| problems with displaying "duplicate vlookup values" in same column | Excel Discussion (Misc queries) | |||
Threaded Mode
