Compare rows in Excel

Hello,

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)

Any suggestions more than welcome

Hello
Does anyone has a suggestion?

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

Is that more clear?

ya now its clear.

Please find attached flow.
compare_rows_for_same_data.zip (19.1 KB)

Hi


I could not open all activities

Does this help to group the data? :wink:

1 Like

1 Like

Hi @kirti.iyer,

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?

Can you suggest?