Help with RANK

[Binkx]

Hi

I need to rank 100+ numbers but I can't get the formula right. All th
numbers are in one column, but not all the rows e.g. I need to Ran
G1:G11 and G13:G25 and G32:G40 etc. How can you put in more than on
reference? The cells G12,G26:G31 etc have numbers in them that I don'
want ranked

RANK(number,ref,order

 

[Ken Wright]

=RANK(G1,MyList) where mylist is a selection of ranges defined with a single
name, eg

select all your ranges and do Insert / Name / Define, then call it MyList. Now
use it in the rank formula and then copy the formula down. You will get error
messages for cells that fall outside the range, so perhaps

=IF(ISERROR(RANK(G1,MyList)),"",RANK(G1,MyList))