Alternate ways to Rank?

Hi

In conjunction with another post I made here, I am creating a Spreadsheet that needs to work in Documents to go.

I am trying to Rank a list of people, but Docs to Go does not support this function.

Can anyone suggest an alternate way to using rank using the compatible functions (visible here http://support.dataviz.com/support.srch?DocID=14404

Many thanks
Neil

RANK can usually be replicated with COUNTIF function, e.g. to rank A1:A10 with highest value ranked 1 you can use this formula in B1 copied down

=COUNTIF(A$1:A$10,">"&A1)+1

if you want to rank lowest value as 1 then change > to <

COUNTIF is on your list......

You can use a twist on COUNTIF() for a basic ranking. With values in A2:A20, put this formula in B2 and count down:

=COUNTIF($A$2:$A$20, "<"&B2) + 1