Hey guys, i'm stuck at this for 4 days. I need a formula to count how many 0's are after each 1, and then to show me the bigest value. Thanksexample.xlsx
Hey guys, i'm stuck at this for 4 days. I need a formula to count how many 0's are after each 1, and then to show me the bigest value. Thanksexample.xlsx
In C3, copied down (and across) use this...
=IF(A3<>0,0,C2+1)
Then a simple =MAX(C3:C22) in C1 and D1 will give you what you need
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks, it's good
Happy to help.
If this answers your question, please mark this thread solved using the thread tools just above your 1st post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks