| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Omits Adjacent Cells | Excel Worksheet Functions | |||
| Formula omits adjacent cells | Excel Discussion (Misc queries) | |||
| Formula omits adjacent cells error message | Excel Discussion (Misc queries) | |||
| make chart based on equation | Charts and Charting in Excel | |||
| How to make one column be the result of an equation between two | New Users to Excel | |||
Linear Mode
