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...
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))
OFFSET($F$7,1,MATCH(MAX(G7:P7),G7:P7,0))
- Thanks Juliano-Petrukio