If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with design | Ronnie | Database Design | 6 | March 12th, 2005 02:53 PM |
Sort or Filter option? | Mcobra41 | Worksheet Functions | 3 | February 23rd, 2005 07:22 PM |
Outline | Renee Hendershott | Page Layout | 2 | December 25th, 2004 02:49 PM |
Deleting rows contains certain text in column A | plumstone | General Discussion | 1 | September 17th, 2004 08:05 PM |
Column E cell contents added into Column D contents (not overwriting data but mixing) | creativetechguy | General Discussion | 2 | August 5th, 2004 07:32 PM |