Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I need help with match formulas that will return discrepancies between two reports. I would like a third table that will return the account number when data from one of the adjacent columns do not match. Although 1183-06 matches, some of them do not. I gave you a sampling of the spreadsheet, there are several dozens rows. For example: Report One: . ..577 386-05..... 1 .... 1 ..... .... .... 1 ...... 455-05..... 1 .... 1 ..... .... .... 1 ...... Report Two: . ..577 386-05..... 1 .... ..... .... .... 1 ...... 455-05..... 1 .... 1 ..... .... .... 1 ...... Return . ..577 386-05..... .... 1 ..... .... .... ...... The result will be a third table that shows me that 386-05 did not have a count for column 325. I hope this example helps. and thanks so much. Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
match formula question | Excel Worksheet Functions | |||
match formula question with isna | Excel Worksheet Functions | |||
match formula question | Excel Worksheet Functions | |||
Match formula question | Excel Worksheet Functions | |||
INDEX/MATCH formula question | Excel Discussion (Misc queries) |