View Single Post
 
Old 03-30-2019, 11:33 PM
Ganesh Kumar Ganesh Kumar is offline Windows 10 Office 2016
Novice
 
Join Date: Mar 2019
Posts: 3
Ganesh Kumar is on a distinguished road
Default 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.
Reply With Quote