Lookup last filled cell in row

  • Thread starter Thread starter Graham Savell
  • Start date Start date
G

Graham Savell

I would like a formula in Col A that will give me the data in the last Col
of each row, i.e Trounce, Ian, Runnalls, Amanda will appear in Col A1:A4

A B C D E F
1 Alison Robert Barrett Trounce
2 Allison Harry Ian
3 Alma William Alwyn Robert Runnalls
4 Amanda

Thanks in advance
 
Graham Savell said:
I would like a formula in Col A that will give me the data in the last Col
of each row, i.e Trounce, Ian, Runnalls, Amanda will appear in Col A1:A4

A B C D E F
1 Alison Robert Barrett Trounce
2 Allison Harry Ian
3 Alma William Alwyn Robert Runnalls
4 Amanda
Click to expand...

Adapting Aladin Akyurek's numeric searching approach to text, try this in
cell A1.

=HLOOKUP(CHAR(255),B1:IV1,1)

Then select A1 and fill it down as far as needed in column A.
 
Only anticipates minimum of 25 names in a row between B and Z,
but enter in A1:
=OFFSET(B1,0,COUNTA(B1:Z1)-1)
and Copy Down..
HTH
 
Back
Top