Hi
I have a spreadsheet giving a total of points at the bottom of different columns.
I need to rank those results in a different row (from 1 to X depending of the numbers of columns being used) but cannot find a function able to do this.
Any tip would be mucho appreciated.
Thanks
There is a function called Rank that might satisfy your needs.
You can find a guide on how to use it in the Formula and Functions User Guide put out by apple. You can find Rank on page 285.
The guide gives you a good description of each function, what its arguments mean, and examples.
Jason
If you want Numbers to tell you what rank a particular number is then you can use RANK like this:
The formula in B3, filled right:
=RANK(B2,$B$2:$E$2,0)
If you want Numbers to list the scores in rank order, then you can use the LARGE function.
The formula in B7, filled right:
=LARGE($B$2:$E$2,B6)
Substitute ; for , in the formulas if your region uses , as a decimal separator.
Note that extensive, up-to-date, and searchable explanations of Numbers functions, in many different languages, are available at Help > Formulas and Functions Help in your menu. If you are offline, you can get the same information via the function browser when you have the right panel open. The function browser appears after you type = into a cell.
SG
Thanks a lot. I had tried both RANK and LARGE but did not use any of them the right way...
Works perfectly with RANK now.
Numbers: how to rank the results in a row
