Return only top result from Filtered list

[Anglais428v2]

I have a formula that works fine:

=LET(u,UNIQUE(FILTER(Country,Sector=$A$1)),SORTBY(u,COUNTIFS(Sector,$A$1,Country,u),-1))

It returns a list of countries ranked highest to lowest by number of records in the database. However I only want to return the top result (i.e. 1 country, not the full list). I thought of trying to incorporate the Large function but not having much luck.

Any advice?

Thanks

 

[Fluff]

How about

=LET(u,UNIQUE(FILTER(Country,Sector=$A$1)),take(SORTBY(u,COUNTIFS(Sector,$A$1,Country,u),-1),1))

 

[Anglais428v2]

Brilliant, thanks Fluff. I'll have to study the Take function - seems very useful!

 

[Muhammad_Usman]

Try this one

=INDEX(LET(u, UNIQUE(FILTER(Country, Sector = $A$1)), SORTBY(u, COUNTIFS(Sector, $A$1, Country, u), -1)), 1)

 

[Fluff]

You're welcome & thanks for the feedback.