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
|
|||
|
|||
Lookup last filled cell in row
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 |
#2
|
|||
|
|||
Lookup last filled cell in row
"Graham Savell" wrote...
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 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. |
#3
|
|||
|
|||
Lookup last filled cell in row
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 "Graham Savell" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|