| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel counting empty cells until first filled one
How about this
assuming your range is in A2 to A10, =COUNTBLANK(A2:A10) or =COUNTIF(A2:A10,"") -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis "Rafael Martinez" wrote: Hello, I need to count how many empty cells there are before hitting first cell with data, I guess there is a way to make a code, macro for this... Thanks Rafael EggHeadCafe - Software Developer Portal of Choice WCF Workflow Services Using External Data Exchange http://www.eggheadcafe.com/tutorials...vices-usi.aspx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code for counting the order cells are filled | Excel Discussion (Misc queries) | |||
| Macro Request: Fill in empty cells with previous Filled cell in column | Excel Worksheet Functions | |||
| Copy Data From Filled to Empty Cells | Excel Discussion (Misc queries) | |||
| Counting filled cells in excel | Excel Worksheet Functions | |||
| Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
Hybrid Mode
