RANK with 0 values
 

I am trying to rank in ascending order a list of numbers where some of the
cells have 0 values. I would like the 0 values to be ignored and not ranked.
Is this possible?

Example:

Col C The ranking I would like:
4813.29 3
7025.59 2
0 [cell would be blank]
0 [cell would be blank]
8287.85 1

RANK with 0 values
 

=IF(A1=0,"",RANK(A1,A1:A5))

--
Gary''s Student - gsnu200715


"JN" wrote:

I am trying to rank in ascending order a list of numbers where some of the
cells have 0 values. I would like the 0 values to be ignored and not ranked.
Is this possible?

Example:

Col C The ranking I would like:
4813.29 3
7025.59 2
0 [cell would be blank]
0 [cell would be blank]
8287.85 1

RANK with 0 values
 

=IF(C1=0,"",RANK(C1,C$1:C$5,0))


--
Regards,

Peo Sjoblom



"JN" wrote in message
...
I am trying to rank in ascending order a list of numbers where some of the
cells have 0 values. I would like the 0 values to be ignored and not
ranked.
Is this possible?

Example:

Col C The ranking I would like:
4813.29 3
7025.59 2
0 [cell would be blank]
0 [cell would be blank]
8287.85 1

RANK with 0 values
 

Thanks so much!!!!

"Gary''s Student" wrote:

=IF(A1=0,"",RANK(A1,A1:A5))

--
Gary''s Student - gsnu200715


"JN" wrote:

I am trying to rank in ascending order a list of numbers where some of the
cells have 0 values. I would like the 0 values to be ignored and not ranked.
Is this possible?

Example:

Col C The ranking I would like:
4813.29 3
7025.59 2
0 [cell would be blank]
0 [cell would be blank]
8287.85 1

RANK with 0 values
 

Hi JN:

Let us try the following in cell D2 ...

=IF(C2=0,"",RANK(C2,C$2:C$6))
and then copying it down.



"JN" wrote:

I am trying to rank in ascending order a list of numbers where some of the
cells have 0 values. I would like the 0 values to be ignored and not ranked.
Is this possible?

Example:

Col C The ranking I would like:
4813.29 3
7025.59 2
0 [cell would be blank]
0 [cell would be blank]
8287.85 1