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
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.