Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculations of Cell after Autofiltering
Hi,
I have autofiltered a Table. The Cells filtered e,g C2, C3, C5, C8, C10, C12, C13, C14, C20, C21.... How may I calculate the diffrenec in values of successive cells i.e C3- C2, C5-C3, C8-C5, C10-C8, C12-C10 etc SUBTOTAL(9, C3,C2) only sums the cells. SUBTOTAL(9, C3,-C2) does not work I attempted using SUBTOTAL(9, C3-C2) but this does not work |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofiltering again | Excel Discussion (Misc queries) | |||
autofiltering | Excel Worksheet Functions | |||
autofiltering | Excel Discussion (Misc queries) | |||
Autofiltering | Excel Discussion (Misc queries) | |||
Autofiltering | Excel Programming |