A formula that counts last consecutive filled cells

[Oi_Oi_Olivia]

Hi all,
This is a brain twister for me but I've looked around and you've helped on similar things so I hope you can help me.
My data looks like this

	7/1	7/2	7/3	7/4	7/5	7/6	7/7	Total	Last consecutive total
1						1	1	2	2
2					1		1	2	1
3	1	1	1		1	1	1	6	3
4	1	1	1	1	1		1	6	1
5	1	1	1	1	1	1	1	7	7

<tbody>
</tbody>

Can you help with a formula for the last column?
For context this is the length of the current period of time in which an event has occurred daily.
TIA,
Olviia

 

[pgc01]

Hi Olivia
Welcome to the board

Try in I2:

=1/LOOKUP(2,1/FREQUENCY(IF(A2:G2<>"",COLUMN(A2:G2)),IF(A2:G2="",COLUMN(A2:G2))))

This is an array formula, you have to confirm it with CTRL-SHIFT-ENTER and not just ENTER.

Copy down

 

[Oi_Oi_Olivia]

Thanks!! That's flippin' magic!
Worked like a charm.

 

[pgc01]

You're welcome. Thanks for the feedback.