how to return numbers with highest value in the range

[tantcu]

Hello,

Is there a formula that will help me return the numbers that have highest value? If there are two numbers have highest value, then it would return two numbers. If there are three numbers have highest value, then it would return three numbers. It can go maxium to 5 numbers.

please see the attached. Test.xlsx

[GC Excel]

Hello tantcu,

See file attached... this is not the prettiest solution but it works.
I use an intermediate table to get the results and I assumed that all # would be different in the same row.

[Mr_HiB]

I'm using Max to get the max frequency value - then an if statment to give you the values for each frequency that matches the Max value.

If you need the values to be sorted then you can copy the values from output and the paste them as values and then sort.

Hope this helps.

Thanks,
Hilmy