| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding similar data in a spreadsheet
I suspect addresses that are duplicated are "similar" rather than exact
matches? You could start by using EXACT function to see if that identifies exact matches or possibly COUNTIF to find multiples. "101guy" wrote: hi, i have a huge spreadsheet with addresses in it. i am trying to consolidate the spreadsheet and getting rid of all the same addresses. what is the quickest way to do this?? at the mo i have sorted and am going through 1 by 1 does anyone know of a quicker way ???? please |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the MAX number while considering similar names | Excel Discussion (Misc queries) | |||
| Finding and Highlighting Similar but not Identical Cells in a Colu | Excel Discussion (Misc queries) | |||
| Finding repeated data in a excel spreadsheet | Excel Discussion (Misc queries) | |||
| How do I sort (or group?) a spreadsheet by similar rows? | Excel Worksheet Functions | |||
| Finding similar data or numbers in two columns | New Users to Excel | |||
Threaded Mode
