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.