INDEX(A1:Z1,1,COUNTA(A1:Z1),1) where it is assumed that the Z1 is as far in the row as your data could be. Otherwise change Z1 to whatever you want. Also, this assumes that there will be no blanks in the columns to the left of the last.
-Denis On Sat, May 11, 2013 at 7:42 AM, David Fleck <[email protected]> wrote: > I don't use spreadsheets very often, so my cell-formula-fu is quite > limited. I'm trying to come up with a way of having a cell (let's call it > 'A1') contain the value of another cell. That other cell will be the last > occupied column of row 1, and it will vary over time. So sometimes I want > A1 to contain the value of E1, because that's the last occupied column; > but other times it should contain the value of W1, because that is the > last occupied column. I rummaged through the Help, but didn't see > anything that obviously solved my problem. > > Can this be done? > > If so, can someone explain how? > > Thanks in advance. > > -- > David Fleck > [email protected] > > _______________________________________________ > PLUG mailing list > [email protected] > http://lists.pdxlinux.org/mailman/listinfo/plug > _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
