Hi There,
I have a data file in excel with the format below. I would like to know the Excel formula so that i can count the number of consecutive 0 to identify number of months no sales per item from the right. Any idea please?
Format:
Item Mth12 Mth11 Mth10 Mth9 Mth8 Mth7 Mth6 Mth5 Mth4 Mth3 Mth2 Mth1 Mth0 Expected Result
A 10 2 1 3 3 4 0 0 0 0 0 0 0 7
B 1 1 0 1 2 1 1 1 1 2 1 0 0 2
C 2 2 2 2 1 3 3 2 1 1 1 1 2 0
Thank you so much - much appreciated.
Best Regards,
Joe
I have a data file in excel with the format below. I would like to know the Excel formula so that i can count the number of consecutive 0 to identify number of months no sales per item from the right. Any idea please?
Format:
Item Mth12 Mth11 Mth10 Mth9 Mth8 Mth7 Mth6 Mth5 Mth4 Mth3 Mth2 Mth1 Mth0 Expected Result
A 10 2 1 3 3 4 0 0 0 0 0 0 0 7
B 1 1 0 1 2 1 1 1 1 2 1 0 0 2
C 2 2 2 2 1 3 3 2 1 1 1 1 2 0
Thank you so much - much appreciated.
Best Regards,
Joe
Last edited: