Forum Discussion
Dazumi30
Aug 22, 2020Copper Contributor
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...
Juliano-Petrukio
Aug 23, 2020Bronze Contributor
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))
Dazumi30
Aug 24, 2020Copper Contributor
Thanks Juliano-Petrukio