Last value in a row

Closed
Jovy - Jul 14, 2015 at 04:27 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 14, 2015 at 11:54 AM
Hello,
I want a cell which is a summary of the entire row values, but it should display the latest value in the row.Suppose I have entered a value anywhere in the row after say 10 blank cells,then the summary cell should reflect this latest value?


Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 14, 2015 at 11:54 AM
jovy, Good afternoon.

Suppose your ROW is: A1:J1

Try to use:

L1 --> =LOOKUP(2,1/(A1:J1>0),A1:J1)

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0