Choose multiple start and end position of window in a row...
1 2 3 4 5 6 7 8 9 10
0 5 3 2 0 0 1 4 6 0
1. Start Time 1.End Time 2. Start Time 2. End Time
I need to scan non zero values in second row and corresponding first row value I need to achieve. Secondary, start of consecutive time slot and end of that time slot should reflect as below
In first start time I need to get 2 and end time as 4
Similarly for second start time I need to get 7 and end time as 9
This need to be updated automatically using formulas even the window vary its position and size can anyone help me with this thanks in advance
For this above example window is 2-4 and 7-9.
Last edited by Ganesh Kumar; 03-31-2019 at 01:55 AM.
|