Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ranking With Sum Product Formulas over Autofiltered Cells
This formula is supposed to assign a rank criteria in Column AI for all names
that match in Column A. It works, to an extent. The problem is the number one rank is a larger number like 166 instead of 1, because there are 165 hidden rows in the range with blank cells in Col AI. These rows were hidden by an advanced filter prior to applying this formula in the top row and copying down. I need to apply this formula after hiding the rows because I don't want to assign ranks to data that do not fit the previous advanced filter screen. Hope this makes sense. Thanks for your help. =(SUMPRODUCT(--($A$13:$A$3000=$A15))+1)-(SUMPRODUCT(--($A$13:$A$3000=$A15),--(AI15<AI$13:AI$3000))+1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Formulas In Cells That Are Not Nested | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Counting Rows/Columns for Copying Formulas | Excel Discussion (Misc queries) | |||
Which Function(s) do I use? | Excel Worksheet Functions | |||
In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) |