Hi :

I had been trying to replicate the result as per row 8 below but failed. Can anyone help ?

1.) Replicate Row 3 column data left to right till the number 0 ignore the rest of the data after 0 for the 1st set of data correspondingly to row 8.
2.) Replicate row 4 column data start after where row 3, 1st set of data ends till number 0 as per (1) to row 8 correspondingly.
3.) Repeat the same for row 5 and 6 onward as per steps (2 & 1) till column K.
4.) Count from left to right row 8 the number of columns it takes to reach 0. Update count result to row 10.
5.) Count the number of occurrence the row 10 data have that is >3 to row 12.

1 A B C D E F G H I J K
2 Date 1 2 3 4 5 6 7 8 9 10
3 Ivan 0 23 12 14 0 21 11 55 0 21


4 Susan 15 12 25 0 17 20 26 0 12 14
5 Henrik 11 0 15 15 26 35 31 0 15 12
6 Tommy 12 15 24 15 0 11 15 18 48 25
7
8 Result 0 12 25 0 26 35 31 0 48 25
9
10 Summary 1 3 4 2
11
12 >3 1

Regards
Loran