G
Guest
I have a number in cell A1, and two lists of numbers in cells D11
21 and
E33:E43
I want to find the rank of cell A1 out of the cells in D11
21 and E33:E43.
But the rank function seems to require that the value in cell A1 be part of
the range D11
21 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
![Big Grin :D :D](/styles/default/custom/smilies/grin.gif)
E33:E43
I want to find the rank of cell A1 out of the cells in D11
![Big Grin :D :D](/styles/default/custom/smilies/grin.gif)
But the rank function seems to require that the value in cell A1 be part of
the range D11
![Big Grin :D :D](/styles/default/custom/smilies/grin.gif)
when the cell values are seperated.
Is there any way around this?
Thanks