| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Last text value in a column
Good evening,
On this forum I've been given formulas by several persons that give the last NUMBER value in a column. I tried to adapt them for TEXT. One of them is working even when there are empty cells in the columns. Unfortunately I couldn't get one working if the texts in the columns are IF based, and the IF function hasn't yet returned a result. In short if there is a empty IF cell below the last filled text cell there is no result at all. Indeed I could arrange to have "0" in these cells but is clumsy and looks akward. Has anyone a hint? Thank you 68magnolia71 |
|
#2
|
|||
|
|||
|
Try...
=LOOKUP(2,1/((A1:A100<"")*ISTEXT(A1:A100)),A1:A100) Hope this helps! In article , 68magnolia71 wrote: Good evening, On this forum I've been given formulas by several persons that give the last NUMBER value in a column. I tried to adapt them for TEXT. One of them is working even when there are empty cells in the columns. Unfortunately I couldn't get one working if the texts in the columns are IF based, and the IF function hasn't yet returned a result. In short if there is a empty IF cell below the last filled text cell there is no result at all. Indeed I could arrange to have "0" in these cells but is clumsy and looks akward. Has anyone a hint? Thank you 68magnolia71 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| I NEED TO SUM NUMBERS ON A COLUMN THAT HAVE TEXT AND NUMBERS | Excel Worksheet Functions | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| How can I make Excel return the text in column A only if there is. | Excel Worksheet Functions | |||
| How to move one piece of text to another column | Excel Discussion (Misc queries) | |||
Linear Mode
