| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determine Row number
In an autofilter -- If I filter on Column A (A5 is header)
and the first data row in Column A is cell A149, how can I extract the 149 to use in a seperate Sumproduct formula =SUMPRODUCT(--(A7:A4620=$A$149),--(L7:L4620="Y"),K7:K4620) TIA, Jim May |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to determine the cell contain number only? | Excel Discussion (Misc queries) | |||
| How to determine the number of month between 2 periods? | Excel Discussion (Misc queries) | |||
| How to determine the number in excel? | Excel Discussion (Misc queries) | |||
| How to determine the number of units? | Excel Discussion (Misc queries) | |||
| Determine number of days | Excel Worksheet Functions | |||
Threaded Mode
