Forum Discussion

AMaxfield's avatar
AMaxfield
Regular Visitor
5 years ago
Solved

Removing duplicates by two columns of data

Hi All

 

I have the folwing data, please see the example looking at the first four rows;

I want to be able to remove the duplicate values of "W/Order" value WA00334 lusing "Op No" and "Date".

 

I only want to retain the higest "Op No" e.g. 25 and the latest date e.g. 22/01/20.

 

So a filter that woudl remove linew 1 to 3 and retain 4 and then effectivly the same for all other data in the table.

 

Any help appreciated 

2 Replies