software

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: www.excelforum.com/member.php...oamp;userid=33771
View this thread: www.excelforum.com/showthread...hreadid=535438=INDEX(B2:L2,,COUNTA(B2:L2))

HTH
--
AP

quot;Tasosquot; gt; a écrit dans le
message de ...
gt;
gt; Hello to all! My first post! Help me if you can.
gt;
gt; I have the list of all months in cells B1:M1 (ie January, February
gt; etc). In the cell under each month (i mean in B2 for January, C2 for
gt; February etc) i enter a number, always number. What is the formula that
gt; i will enter for example in cell A2 and will help me search for the last
gt; cell that contains a number in the area B2:L2 and put it in cell A2?
gt;
gt; I mean if my last input is 150000 in the cell H2 (July), then in cell
gt; A2 to appear the content of H2, ie 150000.
gt;
gt; Thank you in advance.
gt;
gt;
gt; --
gt; Tasos
gt; ------------------------------------------------------------------------
gt; Tasos's Profile:
www.excelforum.com/member.php...oamp;userid=33771
gt; View this thread: www.excelforum.com/showthread...hreadid=535438
gt;

Thank you a lot dear friend. Thank you.--
Tasos
------------------------------------------------------------------------
Tasos's Profile: www.excelforum.com/member.php...oamp;userid=33771
View this thread: www.excelforum.com/showthread...hreadid=535438