How to compare a value in a column with the next value in the same column

Learning Hub
1

Hi,
I need to compare a value in a column with the next value in the same column.if the value is matching then i need to delete the entire row
example
Operation ID2 Number
5168 7515 00001456
5168 7515 00001583
5147 4578 00001256

in ID2 i have 7515 repeated so i have to delete entire row i.e., 5168 7515 00001583
How can I achieve this…Please help.

2

@Sneha2369 It is possible to perform it with a Group BY Clause and select only the First row from the Duplicates.
GroupByAndSum.zip (8.1 KB)

Check the Workflow. After you execute the Workflow. It should generate an Output Sheet in the same Excel

3

Thank you so much @supermanPunch it worked

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.