Keeping Max Count of Records by Person

Question

Hi,

How can I only keep the records where the count is the greatest?

PersonSum_Total HoursCountLouis Stevens4035Louis Stevens421Joe Monroe301Joe Monroe361Joe Monroe37.54

output would be

PersonSum_Total HoursCountLouis Stevens4035Joe Monroe37.54

alexnajm · Answer

Two tools should accomplish this - “Sort” by Count Descending and then “Sample” the First N Records with N=1 and grouping by Person