Choosing duplicate with highest count

olehr

Hi there,

I have a date set with duplicates, but the attached data differs:

So what I want is to choose the duplicate area-code that has the highest count.  Does anyone have a suggestion ? 🙂

Kind regards

Henrik

jdunkerley79

There are a few ways to do this.

The easiest I think is to sort by Area (asc) and Count (desc) and then use a sample tool grouped by area to pick first 1 of each area.

Quick sample attached

Areas.yxmd