View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Formula help with a match question

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