Please help me with achieving below task.
I want to assign same serial number to duplicate values in two columns. If the value in columnB cell matches with any cell in columnC, both will be assigned similar serial number in columnA. Below is the sample data, duplicate value 34 gets same serial number.
<tbody>
</tbody>
I want to assign same serial number to duplicate values in two columns. If the value in columnB cell matches with any cell in columnC, both will be assigned similar serial number in columnA. Below is the sample data, duplicate value 34 gets same serial number.
A | B | C |
1 | 34 | 09 |
56 | 20 | |
20 | 11 | |
21 | 56 | |
1 | 57 | 34 |
11 | 45 | |
09 | 57 | |
45 | 21 |
<tbody>
</tbody>