| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare 2 colmns based off data in other columns
i have a list of deduction codes from 2 different systems on the same
spreadsheet. i'm trying to compare the deduction codes from both lists to see which employees had the deduction come out. i know how to use =isna(match( to compare the deduction codes, but how can i compare the deduction codes based off of employee number? A B C D EE #1 Ded Code1 EE #2 Ded Code2 111 MED 111 MED 222 MED 333 DEN 111 DEN 222 RET 333 RET 333 RET |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare and copy rows of data based on an ID# | Excel Discussion (Misc queries) | |||
| compare data in two columns | Excel Worksheet Functions | |||
| Compare data in two columns | Excel Worksheet Functions | |||
| Need to compare data in 2 columns and not sure how. | Charts and Charting in Excel | |||
| Trying to compare data in two columns... | Excel Worksheet Functions | |||
Threaded Mode
