Last text value in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

=LOOKUP(2,1/((A1:A100<>"")*ISTEXT(A1:A100)),A1:A100)

Hope this helps!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Last value in a column 4
Hide columns based on row values 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
First, Last occurance of date in column 5
Last Modified By in a cell by user 3
Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
SUMIF with criteria "<>" & "=" 4

Back
Top