Emoncada
03-31-2008, 06:19 AM
I have two column's of data about 20 cells down.
Basically what I have is a Total on one spreadsheet then have it look at the other spreadsheet column and see if that total is the same.
What I need if to make sure the data matches, the problem is they won't be in any type of order. What is the best way to make this happen? Should I sort it first?
Example
Spreadsheet 1
Column A..........B
T7316 .............2
6408D .............1
T7316E ...........1
8410D .............2
Total ...............6
*Note both column's will not be the same as in Letter.
Spreadsheet 2
Column J
T7316 .............2
BIS 10 .............2
6408D .............1
T7316E ...........1
Total ...............6
As you can see what's in BOLD. The Total will be the same but Models are different in one of them.
how can i have it test this and if not matching give me a "Check Models" in a cell.
Any Ideas?
Basically what I have is a Total on one spreadsheet then have it look at the other spreadsheet column and see if that total is the same.
What I need if to make sure the data matches, the problem is they won't be in any type of order. What is the best way to make this happen? Should I sort it first?
Example
Spreadsheet 1
Column A..........B
T7316 .............2
6408D .............1
T7316E ...........1
8410D .............2
Total ...............6
*Note both column's will not be the same as in Letter.
Spreadsheet 2
Column J
T7316 .............2
BIS 10 .............2
6408D .............1
T7316E ...........1
Total ...............6
As you can see what's in BOLD. The Total will be the same but Models are different in one of them.
how can i have it test this and if not matching give me a "Check Models" in a cell.
Any Ideas?