| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Checking for duplicate records / rows
Hayley, have a look here for ways to do it,
http://www.cpearson.com/excel/duplic...tingDuplicates -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Hru48" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Checking for duplicate records / rows
Thanks a bunch :) -- Hru48 ------------------------------------------------------------------------ Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895 View this thread: http://www.excelforum.com/showthread...hreadid=516720 |
| Reply |
| 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) | |||
Linear Mode
