Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting

Rank Function (RANK)

Syntax: RANK(number; set; order)

The RANK function returns the rank of a given number in the given set of numbers. You give it a value, a set, and RANK will tell you if the given number is 1st, 2nd, 3rd, and so on.

Figure 7-12. Sample results of the RANK function

For example, if you wanted to know how your company's share of the market is determined, you'd use something like:

=RANK(25%; A161:D161)

RANK returns 3, indicating that your company is the third largest player on the market. You can reverse the order of the ranking if you use the third argument equal to 1 (descending); 0 is ascending, but you can omit that because ...