On Sat, May 11, 2013 at 1:05 PM, Fred James <[email protected]>wrote:
> 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 > > >> > 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 Did you precede INDEX... with an equal sign? Otherwise I do not know what could be causing the problem. You might place =COUNTA(A1:Z1) in another cell to see if that returns the expected value. Then try =INDEX(A1:Z1,1,<that expected value>) to see what you get. Note that the last "1" in INDEX(A1:Z1,1,COUNTA(A1:Z1),1) is optional, and can be dropped. If you need to have blanks in the row but still want the last entry you might be able to start at the end of the row and count blanks, but I am not sure how to do that. -Denis _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
