| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Compare adjacent fields in adjacent rows
I need to flag duplicate names in a spread sheet sorted by Surname,
Given Name (separate columns). In other words... IF (the surname and the given name in row(n) match the surname and given name in the row above(n-1) or below(n+1), display "Dupe", else display " " ) Thank you for your help. Joan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare two text and if equal copy adjacent data | Excel Worksheet Functions | |||
| When data match, copy adjacent value to adjacent column | Excel Worksheet Functions | |||
| compare adjacent cells and calculate averages | Excel Worksheet Functions | |||
| summing values from adjacent column with refrence from adjacent column | Excel Discussion (Misc queries) | |||
| compare contents of two adjacent columns | Excel Worksheet Functions | |||
Threaded Mode
