| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Last non-blank row
I thought I posted the following late this morning. I don't see it,
so I'll try again... Hello: I need to return the last non-blank row of text in a column from one worksheet to a summary worksheet at the front of my workbook. ='Sheet1'!E4 works to return text from cell E4 of Sheet 1. =index(e1:e100,max(row(e1:e100)*(e1:e100<""))) supposedly returns the last non-blank text from a row in a column. However, when I combine the two I get an error: ='Sheet1'!index(e1:e100,max(row(e1:e100)*(e1:e100< ""))) Can anyone educate me? Any feedback is appreciated...Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Last non-blank row
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| where can I down Blank Worksheets, blank stmt. of account forms | Excel Discussion (Misc queries) | |||
| Not showing blank and non blank items in filter mode for values | Excel Worksheet Functions | |||
| How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
Linear Mode
