Y
Yunus
Hi,
I have autofiltered a Table.
The Cells filtered for example in Column C - C2, C3, C5, C8, C10, C12,
C14, C20, C21....
I want to do some calculations on the filtered cells automatically
e,g. In the above example How may I calculate the difference of 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
I have autofiltered a Table.
The Cells filtered for example in Column C - C2, C3, C5, C8, C10, C12,
C14, C20, C21....
I want to do some calculations on the filtered cells automatically
e,g. In the above example How may I calculate the difference of 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