Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count latest number of continous not-empty cells in a row.
Hi Group
I'm not too sure that my subject is clear, but this is what I want to do. In a row I have a range of cells, like this SSS SSS SSS SSS "empty", SSS SSS PPP WWW TTTT "empty" "empty" YY ZZ Now I want to make a UDF to count the number of the last continous not empty cells in this row. In this case the answer is 2, as there is an empty cell before the last two not empty. Regards Jan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to count the number of cells not empty? | Excel Discussion (Misc queries) | |||
Count the number of columns on row that are not empty within a ran | Excel Discussion (Misc queries) | |||
Continous number box | Excel Discussion (Misc queries) | |||
count number of non empty columns | Excel Programming | |||
Count Empty Cells in Range After Cells with Data | Excel Programming |