Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Zeros in a row until encounter first non-zero value
Is there a function, or combination of nested functions to count the number
of zeros in a row up until the first non-zero valued cell? For Example 0 0 0 0 0 35 0 50 60 0 0 0 0 0 0 40 10 0 0 30 For the First Row I want the function to return the value 6 and the second row to return the value '7' I do not want to know the total number of zeros in a row, I want to know the number of zeros in a row until I encounter the first nonzero cell. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to savage a file that crashes? "Microsoft encounter a problem. | Excel Discussion (Misc queries) | |||
Close Excel 2007 and encounter a problem | Excel Discussion (Misc queries) | |||
Extract everything to the right in cell when a number is encounter | Excel Worksheet Functions | |||
Error encounter when i try to click a hyperlink in Excel | Excel Discussion (Misc queries) | |||
Counting number of consecutive zeros at the end of a list | Excel Discussion (Misc queries) |