excellmate
New Member
- Joined
- Jan 28, 2006
- Messages
- 15
Problem:
Columns A to C contain related data - (A)date, (B)number,(C) monetary value.
Column D is blank
Columns E to S contain related data - (E)date,(F)number,(G)monetary value,(H) to (S)analysis of data in column (G).
What I want to do is match and compare the numbers in columns B and F and populate column D with the difference betwen the monetary values in columns C and G. The numbers in columns B and F are sorted in ascending order and they should match but my problem is that there are gaps in the numbers resulting in columns A to C being about 9000 rows long and columns E to S being about 14000 rows long. I need to find what numbers are in column B but which are not in column F and vice versa. There is a $500k difference in the totals of columns C and G and I need to find out where the discrepancy is !!
I tried comparing manually but it would take days to complete. Any help on saving time would be appreciated.
Columns A to C contain related data - (A)date, (B)number,(C) monetary value.
Column D is blank
Columns E to S contain related data - (E)date,(F)number,(G)monetary value,(H) to (S)analysis of data in column (G).
What I want to do is match and compare the numbers in columns B and F and populate column D with the difference betwen the monetary values in columns C and G. The numbers in columns B and F are sorted in ascending order and they should match but my problem is that there are gaps in the numbers resulting in columns A to C being about 9000 rows long and columns E to S being about 14000 rows long. I need to find what numbers are in column B but which are not in column F and vice versa. There is a $500k difference in the totals of columns C and G and I need to find out where the discrepancy is !!
I tried comparing manually but it would take days to complete. Any help on saving time would be appreciated.