Last value in a row

[Closed]
Report
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
-
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?


1 reply

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
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