Hello,

I'm trying to build a power query that sorts out duplicate values by the maximum in one column. I have duplicate values in column "WO #" and unique values in "Last seen on". I want to remove duplicate rows by column "WO #" and keep the maximum by column "Last seen on"
I'm thinking a MAXIF that returns a true/false based on max range = "Last seen on" with a criteria range of "WO #" and criteria = "WO #" and then filter by true/false, but I cant seem to get the syntax right inside query editor.