"Right most" Information

[telton]

Is the there a formula to look at a particilar series of columns in a row of data, and bring back the the information from the last (right most column) that has data in it...

Hope this makes sense.

Thanks

[DonkeyOte]

Yes.

Routes will vary based on data type...

Always number:

=LOOKUP(9.99999999999999E+307,$1:$1)

Always text

=LOOKUP(REPT("Z",255),$1:$1)

Always Logical

=LOOKUP(TRUE,$1:$1)

Mix

=LOOKUP(2,1/($1:$1<>""),$1:$1)

For more detailed info. on techniques for "finding last values" see Bob Phillips' article: http://www.xldynamic.com/source/xld.LastValue.html