Y
Yunus Patel
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
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