count the number of blank cells from the last entry

**Gerz** · 07-11-2013, 10:23 PM

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

**benishiryo** · 07-11-2013, 10:50 PM

hi Gerz, welcome to the forum. in O2, try:
=IFERROR(12-LOOKUP(2,1/(B2:M2<>""),COLUMN(B2:M2)-COLUMN(B2)+1),"never checked")

**Debraj Roy** · 07-11-2013, 11:05 PM

Try This..

Formula:

Please Login or Register  to view this content.

**Gerz** · 07-12-2013, 02:18 AM

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.

Is it possible or would I need macro already?

Sample template attached.