Make sure the numbers that you are ranking are in column E, because that is
the column being referenced, and when you enter the functionmake sure you
hold down the Control key and the Shift key and the Enter key ALL AT THE SAME
TIME (or hold down CTRL then hold down Shift then hold down Enter). Try it;
it should work fine for you...


Regards,
Ryan--

--
RyGuy


"JBG" wrote:

I copied the numbers that were in row D into row E should I just have that
row empty and is that why it is still not working?

"ryguy7272" wrote:

Try this:
=IF(E1="","",SUMPRODUCT(--(E1<E$1:E$34),1/COUNTIF(E$1:E$34,E$1:E$34&""))+1)
Ctrl+Shift+Enter

Or this:
=RANK(E1,$E$1:$E$34)
Ctrl+Shift+Enter


Regards,
Ryan---


--
RyGuy


"JBG" wrote:

In my workbook I have a set of numbers that I want to rank. I have a empty
colomn and when I use the rank function it displays the error window. I know
I am making this harder than needed. What do I use in the number, ref,
order? The numbers I want to rank numbers E4:E34 and have column F empty.