Hello Everyone
I’m automating a process that uses excel file. What I wanted to achieve is to check if the first record/row and the succeeding records/rows have the same combination. For example…
Column filters/combination (ID – Name – Age – Work)
ID – Name – Age – Company – Work
1 – James – 20 – Company A – Dev
1 – James – 20 – Company B – Dev
2 – James – 20 – Company C – Dev
3 – Merlin – 20 – Company C – Dev
4 – Merlin – 20 – Company C – Dev
In this sample, I want to identify or output the records that have the same combination of (ID, Name, Age, and Work) and that do not have same combination as well.
Expected output
ID – Name – Age – Company – Work
1 – James – 20 – Company A – Dev (treated as one)
1 – James – 20 – Company B – Dev (treated as one)
2 – James – 20 – Company C – Dev (tread as independent)
3 – Merlin – 20 – Company C – Dev (tread as independent)
4 – Merlin – 20 – Company C – Dev (tread as independent)