Last non-blank cell in a row?
 

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.


--
Tasos
------------------------------------------------------------------------
Tasos's Profile: http://www.excelforum.com/member.php...o&userid=33771
View this thread: http://www.excelforum.com/showthread...hreadid=535438

Last non-blank cell in a row?
 

=INDEX(B2:L2,,COUNTA(B2:L2))

HTH
--
AP

"Tasos" a écrit dans le
message de ...

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.


--
Tasos
------------------------------------------------------------------------
Tasos's Profile:
http://www.excelforum.com/member.php...o&userid=33771
View this thread: http://www.excelforum.com/showthread...hreadid=535438

Last non-blank cell in a row?
 

Thank you a lot dear friend. Thank you.


--
Tasos
------------------------------------------------------------------------
Tasos's Profile: http://www.excelforum.com/member.php...o&userid=33771
View this thread: http://www.excelforum.com/showthread...hreadid=535438