count the number of blank cells from the last entry
Please read update on thread # 4 of this page.
------
Hi this maybe kinda hard to explain but I'm attaching a sample to better explain it better.
I need a formula that can tell me the number of blank cells between the last data and the end of a row.
There may be some blanks in between data but only need to start count after the last entry.
Please refer to the file.
Thanks
Last edited by Gerz; 07-12-2013 at 02:21 AM.
Reason: update
Re: count the number of blank cells from the last entry
Thanks, both Debra and benishiryo. I'm loving this place. They both worked and managed to incorporate them in my current work.
Now though, I have a template in mind involving using a pivot to create a gantt chart. And would like to know how I can incorporate this lookup to it.
Even gets trickier because it involves dates.
Bookmarks