I have the excel sheet with 3 columns and n number of rows.
I have to compare 1 row with 2 row and if the data from first column are the same then compare 2 row with 3 row and if the data from first column are the same then…
When rows doesnt match (we compare only information from 1column) lets say we are now copare 5 row with 6 row, I want to copy all above rows, so 1,2,3,4,5
Then I have to start compare from row 6…
Example of report in the attachement
Report.xlsx (9.2 KB)
Any suggestions more than welcome