My case
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)
Hi, The below condition is not clear. Please provide a input as well as expected output for better understanding.
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…
Input below report Report.xlsx (9.2 KB)
Output
I need to copy data from columns: A,B,C when data from column A are the same Report (1).xlsx (9.5 KB)
Each time my report will contain different data
This seems to be a reasonable solution.
However as a results I look for storing data (maybe in array) for the same Vendor name in variable so I can paste them into mail message?
