What formula/function would let me count blank cells up a column until it reaches a non-blank cell. The column contains cells that are either blank or contain numbers. I would like the formula to count blank cells until it reaches the first cell containing numbers.
You didn't give a range, so I'll assume you mean from the very bottom and I'll use Column A.
=COUNTBLANK(INDIRECT(CELL("address",INDEX(A1:A1048576,MATCH(2,INDEX(1/(1-ISBLANK(A1:A1048576)),0))))&":A1048576"))
Let's confidently assert some more:
Your last cell has data in A12. The count of blank cells between A12 and A1048576 is 1048564.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Pl see attached file
Hi kvsrinivasamurthy,
Based on your formula, if I wanted to count the roll instead of column, do I change the "COLUMN" in your formula to "ROLL"?
Thanks,
Josh
Hi Josh, welcome to the forum
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
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
I found an excel file here in which the given formula is working for column, I want this for ROW, please help
Regards,
Kamran
PAKISTAN.
Excel - 2007
This is the formula
=IFERROR(IF(D1<>"",LARGE(IF($C$1:C1="",COLUMN($C$1:C1),""),1)-LARGE(IF($C$1:C1<>"",COLUMN($C$1:C1),""),1),""),"")
and I wana adjust in A:A
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks