Hi,
I want to subtract filtered cells ---each filtered cell from the previous filtered cell---
thanks in a
I want to subtract filtered cells ---each filtered cell from the previous filtered cell---
thanks in a
Excel Workbook | ||||
---|---|---|---|---|
A | B | |||
3 | Result | |||
2643 | 24-03-1937 | |||
2644 | 25-03-1937 | 1 | ||
2645 | 26-03-1937 | 1 | ||
2646 | 27-03-1937 | 1 | ||
2647 | 28-03-1937 | 1 | ||
2648 | 29-03-1937 | 1 | ||
2649 | 30-03-1937 | 1 | ||
2650 | 31-03-1937 | 1 | ||
2651 | 01-04-1937 | 1 | ||
2652 | 02-04-1937 | 1 | ||
2653 | 03-04-1937 | 1 | ||
2654 | 04-04-1937 | 1 | ||
2655 | 05-04-1937 | 1 | ||
2656 | 06-04-1937 | 1 | ||
2657 | 07-04-1937 | 1 | ||
3000 | 16-03-1938 | 343 | ||
3001 | 17-03-1938 | 1 | ||
3002 | 18-03-1938 | 1 | ||
3003 | 19-03-1938 | 1 | ||
3004 | 20-03-1938 | 1 | ||
3005 | 21-03-1938 | 1 | ||
3006 | 22-03-1938 | 1 | ||
3007 | 23-03-1938 | 1 | ||
3008 | 24-03-1938 | 1 | ||
3009 | 25-03-1938 | 1 | ||
3010 | 26-03-1938 | 1 | ||
3011 | 27-03-1938 | 1 | ||
3012 | 28-03-1938 | 1 | ||
3013 | 29-03-1938 | 1 | ||
3014 | 30-03-1938 | 1 | ||
3015 | 31-03-1938 | 1 | ||
3016 | 01-04-1938 | 1 | ||
3039 | 24-04-1938 | 1 | ||
3040 | 25-04-1938 | 1 | ||
3041 | 26-04-1938 | 1 | ||
3042 | 27-04-1938 | 1 | ||
3043 | 28-04-1938 | 1 | ||
3044 | 29-04-1938 | 1 | ||
3045 | 30-04-1938 | 1 | ||
3046 | 01-05-1938 | 1 | ||
3047 | 02-05-1938 | 1 | ||
3048 | 03-05-1938 | 1 | ||
3049 | 04-05-1938 | 1 | ||
3050 | 05-05-1938 | 1 | ||
3051 | 06-05-1938 | 1 | ||
3052 | 07-05-1938 | 1 | ||
3053 | 08-05-1938 | 1 | ||
3054 | 09-05-1938 | 1 | ||
3055 | 10-05-1938 | 1 | ||
3056 | 11-05-1938 | 1 | ||
3057 | 12-05-1938 | 1 | ||
3058 | 13-05-1938 | 1 | ||
3059 | 14-05-1938 | 1 | ||
3060 | 15-05-1938 | 1 | ||
3061 | 16-05-1938 | 1 | ||
Sheet1 |