Forum Discussion
Formula Help - Create formula based on last column entry
Hi all, Apologies if this query has come up previously.. I am trying to create a simple formula in column B that uses the latest column of filled data (i.e. column E in the screenshot below) an...
One other way I believe you could do it:
=100*LOOKUP(MAX(C3:XFD3)+1,C3:XFD3)/LOOKUP(MAX(C3:XFD3)+1,C3:XFD3,C$6:XFD$6)
Since I don't know how far your data will extend to the right, I went all the way to the last column (XFD). If your table has a definite boundary, then use that column instead.