Identify cell location from last cell in row with a value greater then 0

I have a simple format of Month/Yr above a count value. I want to identify the Month/Yr in sequential order that is the next month in the sequence that does not have a value. The goal is to find the next month that I will forecast and continue to move that as month end data is populated.

JUL-18 AUG-18 SEP-18 OCT-18 NOV-18
12345 15867 14976


Using this sample from the sheet. I want to know which cell in row 2 is the last to have a value is greater than 0 (14976 which is in cell AQ2) and the use the offset function to return an answer which would be Oct-18 (in cell AR1) in this sample ( Over 1 and Up1)

try this

Formula:

Please Login or Register  to view this content.

note: use limited ranges instead entire rows

Formula:

Please Login or Register  to view this content.

Hi Jose,
The formula worked but only identified the cell value above the last entry in row 2. I added a +1 to the aggregate formula and it works perfect. Thank You

Hi @spyac

You are welcome.

I do not see next month in the sequence ...


Regards

Hi Jose
I'm not familiar with the aggregate function. How do I limit the range in the formula as you suggested?

Use this general example with your data in M1:ZZ....

Formula:

Please Login or Register  to view this content.

Note the -column(M$1)+1 to adjust the start plus one for next month

Thanks again for the range adjustment method