Determine last cell in a row

[liz]

Help! I am creating an equation that needs to refernce the last cell in a
row. How can I determine the cell address? The information in the row is
text.

Thanks for your help!

 

[Aladin Akyurek]

=CELL("Address",INDEX(1:1,MATCH(REPT("z",255),1:1))

would give you the address of the last text-valued cell from row 1.

A2:INDEX(2:2,MATCH(REPT("z",255),2:2)

would calculate a range spanning from A2 to to the last text-valued cell in
row 2.

 

[sutha]

I am a new user. Please help with the following
How can I reference the last cell updated with numbers in a raw?
example colum a b c d e f are days on raw number 2. I like to have the last
day updated number on column g.
Thanks

 

[T. Valko]

How can I reference the last cell updated with numbers in a raw?

This will return the rightmost numeric value from the referenced range:

=LOOKUP(1E100,A1:F1)