Last Period

[muralli]

I need to calculate the "Last Period" based on the values available in the Columns P1 to P5. Is there a formula that can be built to this situation?

Store / Period	P1	P2	P3	P4	P5	Last Period
Str1	6	7	8	0	0	3
Str2	24	4	5	66	7	5
Str3	1	0	2	0	0	2
Str4	1	1	1	10	0	4
Str5	1	1	1	1	1	5

 

[jasonb75]

If the result for Str3 is correct then =COUNTIF(B2:F2,">0")

 

[muralli]

If the result for Str3 is correct then =COUNTIF(B2:F2,">0")

Sorry, that was a typo.. for Str3, the result should be 3 and not 2.

 

[jasonb75]

In that case try one of

=MATCH(2,INDEX(1/(B2:F2>0),0))

=LOOKUP(2,1/(B2:F2>0),B$1:F$1)

 

[muralli]

In that case try one of

=MATCH(2,INDEX(1/(B2:F2>0),0))

=LOOKUP(2,1/(B2:F2>0),B$1:F$1)

Dear Jason, this is amazing... both solutions are working as desired.

Thank you