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 · Accepted solution]

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

[olehr]

Thanks. 

The solution was simpler than I thought 🙂