Forum Discussion
Returning the last value of a row to another cell
Hi team, Could someone help with a formula to return values from a range of cells to a particular cell depending on dates. For example, the last cell value of that row is always copied to another c...
There are several ways to get it.
The general idea is to get the latest date. You can get it by using the MAX() formula for example.
Once you know the most recent date, what you need to to is find the "position" of this value. This you can get by using the MATCH() formula. =MATCH(MAX(G7:P7);G7:P7;0). It will give you the position of the value.
Once you know the position you can use a formula like OFFSET() to displace up to the value, I mean, returning the value of tha position.
=OFFSET($F$7;1;MATCH(MAX(G7:P7);G7:P7;0))
Thanks for your response. However, the formula is not working, it gives me an error when entered.
- Replace semi-colon(;) by comma (,)
OFFSET($F$7,1,MATCH(MAX(G7:P7),G7:P7,0))- Thanks Juliano-Petrukio