Last value Cell/Row

[an]

Helo!

I have:

A B C D
x
n k
w n p
f j y z

I need to obtain, in E column, the value of last cells not
null in row. Or:

A B C D E
x x
n k k
w n p p
f j y z z

Is it possible in Excel?
Thanks in advance.
an

 

[Frank Kabel]

Hi
if you only have text entries in your range (no numbers) you may try
the following in E1
=HLOOKUP(REPT("z",255),A11,1)
copy down

 

[Andy B]

Hi

Try this:

=OFFSET(E1,0,COUNTA(A11)-5)

and fill down

Andy.

 

[an]

Ok!
Many thanks, but, sometimes... there are numbers (?)
an

 

[Bob Phillips]

An,

Try this then

=INDEX(A22,1,MAX(IF(A22<>"",COLUMN(A22)))-COLUMN(A22)+1)

it's an array formula, so commit with Ctrl-Shift-Enter

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Or try the following non array formula (though a little bit more
complex)

=INDEX(A11,MAX(IF(ISNUMBER(MATCH(REPT("z",255),A11)),MATCH(REPT("z"
,255),A11),0),IF(ISNUMBER(MATCH(2E+30,A11)),MATCH(2E+30,A11),0)))

 

[an.Thanks]

Many thanks for all.

You help me with yours solutions!
an