I have a number in cell A1, and two lists of numbers in cells D11:D21 and
E33:E43
I want to find the rank of cell A1 out of the cells in D11:D21 and E33:E43.
But the rank function seems to require that the value in cell A1 be part of
the range D11:D21 or E33:E43. It does not seem to allow me to take the rank
when the cell values are seperated.
Is there any way around this?
Thanks
Bookmarks