| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Blank (empty) cell always equal to 0?? | Excel Discussion (Misc queries) | |||
| Setting Purely BLANK Cell | Excel Worksheet Functions | |||
| Replace null string with blank cell | Excel Discussion (Misc queries) | |||
| Look for change next blank cell in Range | Excel Worksheet Functions | |||
Linear Mode
