Count blank cells right to left where range is based on column header

example.jpg

I run a large number of programs where I receive deliveries and manually enter the number delivered into the row of the program and the fixed date in the header.

I need a function (or VBA) that will update automatically to locate the column header with today's date and in the corresponding row count the number of blank cells (counting backwards) until it reaches a cell with a value other than blank.

Because I run hundreds of programs, it is easy to miss when I have not received a delivery in a long period of time. The image attached should provide a more clear example of what I am looking to accomplish.

Many members are unable to see images in the *.png format due to forum compatibility issues with some browsers.

If you need to post an image post it in the *.jpg format.

Even better than posting images... post a SMALL sample file. That way we can test solutions directly in the file with the relevant data.

With today's date in A1 and 'Days Since Last Delivery' in column A try array entering this formula in A3 and fill down until you get blanks. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

Please Login or Register  to view this content.

MATCH(2,1/ISNUMBER(B3:P3),1)

You can shorten that a bit...

MATCH(1000,B3:P3)

Or...

MATCH(1E100,B3:P3)

Then, just a normal Enter will do.

@ Tony Valko

Yup!

Thanks for that.

Reciprocating has become a habit.