| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Checking for duplication on rows
Presume you're checking some specific names ?
One way to quickly check is to use autofilter (Data Filter Autofilter) Select "Custom" from the droplist, then enter/paste the specific name OK Then reset the droplist to "(All)", repeat the check for each col concerned -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Karmen" wrote in message ... Hello, In a particular spreadsheet, I would like to verify if the same name is listed on multiple rows. The name is entered in multiple columns on the same row, that is acceptable, but I would like to know if the name is entered on multiple rows regardless of the column. How can I check this? THANKS, karmen -- Karmen ------------------------------------------------------------------------ Karmen's Profile: http://www.excelforum.com/member.php...o&userid=30972 View this thread: http://www.excelforum.com/showthread...hreadid=509495 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rows & Columns in Excel | Excel Worksheet Functions | |||
| Automatically inserting rows | Excel Worksheet Functions | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| Insert rows | Excel Worksheet Functions | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Threaded Mode
