Top 5 numbers in a range

[Thehub]

I have a table with 130 rows and 5 columns. Each cell contains an integer between 1 and 49 inclusive. No number is repeated within a row.

I need to find the top 5 different numbers within that range. Anyone help?

 

[afonsomira]

Here is one solution.
Top1 = =LARGE($A$1:$E$130,1)
Top2 = =LARGE($A$1:$E$130,2)
Top3 = =LARGE($A$1:$E$130,3)
Top4 = =LARGE($A$1:$E$130,4)
Top5 = =LARGE($A$1:$E$130,5)

 

[Fluff]

What version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.

 

[Thehub]

What version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.

Done. Thanks for the reminder.

 

[Fluff]

Thanks for that.
As you have 365 another possible option is

=LARGE(A1:E130,SEQUENCE(5))

 

[Thehub]

Here is one solution.
Top1 = =LARGE($A$1:$E$130,1)
Top2 = =LARGE($A$1:$E$130,2)
Top3 = =LARGE($A$1:$E$130,3)
Top4 = =LARGE($A$1:$E$130,4)
Top5 = =LARGE($A$1:$E$130,5)

Unfortunately, this only gives the single most frequent number. But thanks for your help

 

[Thehub]

Thanks for that.
As you have 365 another possible option is

=LARGE(A1:E130,SEQUENCE(5))

Unfortunately, this only gives the single most frequent number. But thanks for your help

 

[Fluff]

What exactly are you looking for?
The top 5 per row, the top 5 per column?

 

[afonsomira]

Could you leave an example of your spreadsheet here so we can help you better?

Thanks!

 

[Fluff]

Having re-read your op do you want the top 5 unique numbers from the entire data?
Also do you have the LET function in your version of Excel?