Want the 5 hottest numbers of the list!

[Seafreight Discounte]

Hi,

Can someone help me. I created a column which generates random numbers between 1 and 25. But now
I want the second column D to show the 5 hottest random numbers starting with the hottest one. And beside that
column in E I want to see how much each number got repeated.

Can someone help me with this probably easy task?

Thanks a bunch.

[Richard Buttrey]

Please define hottest.

Do you have Excel 365 or perhaps Excel 2019. This will make it easier to avoid duplicate random numbers.

If you mean largest then perhaps in D3 copied down
=LARGE($B$3:$B$32,ROW()-2)

You'll need to copy this down more than 5 rows to avoid duplicates. Then Use a COUNTIF() function in column E.

[Seafreight Discounte]

I have office 2010 lol.

Hottest numbers are the ones that repeated most.

I'm not very proficiant with the software, I added your formula in D3 but it doesn't convert to anything.

[thenewkidd]

This is how I would do it.

A series of ranking

However, "RANDBETWEEN" is a volatile formula and will change every time something updates
so your data set will literally be random and change every update to the workbook.