Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill Series Calculations with Autofilter ON
Hi,
Perhaps I'm not explainig this correctly. I have activated Autofilter. I want to make subtractions referencing the visible rows, yet using drag/filll handle it still references hidden cells. e.g if, in column C, the visible cells are C2, C4, C5, C7, C8, C9, C10 and in Column D I enter =C4-C2, then drag this down regardless of what visible cells are displayed the series will follow C6-C4, C8-C6, C10-C8, C12-C10 etc instead of C5-C4, C7-C5, C8-C7, C9-C8, C10-C9 SUBTOTAL(9, C4,C2) works but only for summation NOT SUBTRACTION. Anyone have any ideas please. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i use series autofill when I use autofilter? | Excel Discussion (Misc queries) | |||
Fill Series Dates: not letting me change the series from year to m | Excel Discussion (Misc queries) | |||
Maximum Value of a Cell over a series of calculations | Excel Discussion (Misc queries) | |||
Edit Fill Series - How do I fill using minute increments | Excel Discussion (Misc queries) | |||
Filling in a Date Series using the Fill | Series menu command | Excel Programming |