Last non-blank cell in a row?

[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.

[Ardus Petus]

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

HTH
--
AP

"Tasos" <[email protected]> a écrit dans le
message de news:[email protected]...
>
> 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
>

[Tasos]

Thank you a lot dear friend. Thank you.