| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking for duplicate records / rows
Hey all, Right, here's my problem - I have a spreadsheet with thousands of records and I need to check to see iff any of them are duplicated. In column A I have a ZIP codes which are sorted into ascending order, so can anyone think of a way of checking through this column to see if any one zip matches the zip above it or below it? Many thanks, Hayley -- Hru48 ------------------------------------------------------------------------ Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895 View this thread: http://www.excelforum.com/showthread...hreadid=516720 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rows & Columns in Excel | Excel Worksheet Functions | |||
| How to swap rows and columns? | Excel Discussion (Misc queries) | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| How set up a template/form & database that records variable rows . | Excel Discussion (Misc queries) | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Threaded Mode
