Hi

I would like to enter a RANK functino that refers to more than one range
when performing the rank calculation - is this possible? e.g.

I have numbers in A1:A10 and in C5:C15.

Can I do a rank that ranks a value in A5, say, in terms of its order within
ranges A1:A10 and C5:C15 combined?

e.g. something like =rank(A5,{A1:A10,C5:C15})

^note the above formula doesn't work but I hope illustrates the problem I'm
trying to solve.

Regards