Denis Heidtmann wrote: > 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] >> Denis Heidtmann I am trying to impliment your interesting solution, but I keep getting ... ERR:508; Error:Missing pair,;"Missing bracket, for example, closing brackets, but no opening brackets " Thank you for any further assistance you may be able to offer Regards Fred James
_______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
