sharc316
04-03-2017, 06:25 PM
Hi,
Wondering if someone can help me accomplish the following: I would like to take a value from A1 (0089) and B1 (7191) and see if there is the reverse value anywhere in these columns ex: A2 (7191) and B2 (0089).
Then in column C would like to name these two rows with the same value; "1" in this example. Would like this check to be performed for every row and name these values with same label when true.
Thank you for your help.
A
B
C
0089
7191
1
7191
0089
1
0089
7642
2
7642
0089
2
0089
0132
3
0132
0089
3
0089
0923
4
Wondering if someone can help me accomplish the following: I would like to take a value from A1 (0089) and B1 (7191) and see if there is the reverse value anywhere in these columns ex: A2 (7191) and B2 (0089).
Then in column C would like to name these two rows with the same value; "1" in this example. Would like this check to be performed for every row and name these values with same label when true.
Thank you for your help.
A
B
C
0089
7191
1
7191
0089
1
0089
7642
2
7642
0089
2
0089
0132
3
0132
0089
3
0089
0923
4