tricoachmartin
New Member
I need to compare two tables to see if they have the same value for the same codes. One table has the codes expressed in a range (one column with the first code of the series and the second column with the last coed in the series). In the other table every code is listed individually. How can I find the codes that don't match? I have put a simplified version of the table below noting code values that I would want the formula to find. Thank you in advance.
Table 1
Beg Code | End Code | Price
1 | 5 | $15.00
6| 6 | $20.00
7| 8 | $5.00
9| 11 | $3.00
12 | 12 | $8.00
13 | 13 | $25.00
14 | 20 | $10.00
Table 2
Code |Price
1 |$15.00
3 |$15.00
4 |$17.00 - PRICE IS DIFFERENT
6 |$20.00
9 |$3.00
10 |$3.00
11 |$3.00
12 |$10.00 - PRICE IS DIFFERENT
13 |$25.00
15 |$10.00
16 |$10.00
17 |$10.00
Table 1
Beg Code | End Code | Price
1 | 5 | $15.00
6| 6 | $20.00
7| 8 | $5.00
9| 11 | $3.00
12 | 12 | $8.00
13 | 13 | $25.00
14 | 20 | $10.00
Table 2
Code |Price
1 |$15.00
3 |$15.00
4 |$17.00 - PRICE IS DIFFERENT
6 |$20.00
9 |$3.00
10 |$3.00
11 |$3.00
12 |$10.00 - PRICE IS DIFFERENT
13 |$25.00
15 |$10.00
16 |$10.00
17 |$10.00