How do I make a rank equation that omits particular cells?
 

I have sales figures for certain reps in column E, and am trying to rank them
all in column H. The problem is that they are grouped by region and column E
also includes the regional totals. How do I specify the range while omitting
the four cells in colum E that have the regional fiigures? I need to rank
the reps only and the celss that contain the regional figures throws the
ranking off. Right now I have the formula as =RANK(E2,E:E). This includes
cells that I would like to omit in the calculation. Can someone please help?
Desperate. Thanks!

How do I make a rank equation that omits particular cells?
 

The solution is easy if the regional totals are always larger than any
individual rep. If this is true, then the regional total cells will always
rank 1,2,3,4

Thus to compensate for this, use:

=RANK(E2,E:E)-4

I will admit that this approach is a little cheesy, but what the heck?
--
Gary''s Student - gsnu200857


"KSL" wrote:

I have sales figures for certain reps in column E, and am trying to rank them
all in column H. The problem is that they are grouped by region and column E
also includes the regional totals. How do I specify the range while omitting
the four cells in colum E that have the regional fiigures? I need to rank
the reps only and the celss that contain the regional figures throws the
ranking off. Right now I have the formula as =RANK(E2,E:E). This includes
cells that I would like to omit in the calculation. Can someone please help?
Desperate. Thanks!