Hi all,
I have two tables, these are as follows:
Customer Number | PO Number
1 | 1123
1 | 1129
2 | 1126
3 | 1124
4 | 1164
4 | 1243
Customer Number | PO Number
1 | 1123
2 | 1129
3 | 1124
4 | 1164
4 | 1243
I want to compare the two tables to see which customer and related PO are in each (whilst considering that a customer can have multiple PO numbers.
The columns I envisage being in the comparison are:
Customer Number | PO Number | In table 1? | In table 2?
How could I do this in excel such that the comparison table doesn't have duplicates of each row.
I.e. customer number 14 and PO 4 maybe be in both tables, I don't want to copy the data from both tables into a new worksheet as this will create duplicates.
I am racking my brain over this....
Any help appreciated.
Thanks,
Harry
I have two tables, these are as follows:
Customer Number | PO Number
1 | 1123
1 | 1129
2 | 1126
3 | 1124
4 | 1164
4 | 1243
Customer Number | PO Number
1 | 1123
2 | 1129
3 | 1124
4 | 1164
4 | 1243
I want to compare the two tables to see which customer and related PO are in each (whilst considering that a customer can have multiple PO numbers.
The columns I envisage being in the comparison are:
Customer Number | PO Number | In table 1? | In table 2?
How could I do this in excel such that the comparison table doesn't have duplicates of each row.
I.e. customer number 14 and PO 4 maybe be in both tables, I don't want to copy the data from both tables into a new worksheet as this will create duplicates.
I am racking my brain over this....
Any help appreciated.
Thanks,
Harry