Last non-blank cell in a row?

  • Thread starter Thread starter Tasos
  • Start date Start date
T

Tasos

Hello to all! My first post! Help me if you can.

I have the list of all months in cells B1:M1 (ie January, February
etc). In the cell under each month (i mean in B2 for January, C2 for
February etc) i enter a number, always number. What is the formula that
i will enter for example in cell A2 and will help me search for the last
cell that contains a number in the area B2:L2 and put it in cell A2?

I mean if my last input is 150000 in the cell H2 (July), then in cell
A2 to appear the content of H2, ie 150000.

Thank you in advance.
 
Back
Top