text substitution
 

I have a spread sheet that tracks equipment for our company. I split the
screen because I record fuel usage and meter readings on a number of pieces
of equipment. Part of the record indicates which of our project sites the
equipment is located at. At the beginning of the month, I type the site
location in a cell and as the month progress, I type the name of the new site
if the equipment moves in a cell on that same line. What I would like to do
is have the original cell be updated any time I type a new location in that
line. Any help would be appreciated.

text substitution
 

Let's say you want cell A1 to contain the most recent value in the first row.
So if we start with a value in B1, then we see that value in A1. If we
later enter a value in C1, then A1 changes to this value.

The desire is that A1 reflect he last (right-most) value in the row. In A1
enter:

=LOOKUP(2,1/($B$1:$IV$10),$B$1:$IV$1)

this should do the trick.
--
Gary''s Student - gsnu200802


"Mark" wrote:

I have a spread sheet that tracks equipment for our company. I split the
screen because I record fuel usage and meter readings on a number of pieces
of equipment. Part of the record indicates which of our project sites the
equipment is located at. At the beginning of the month, I type the site
location in a cell and as the month progress, I type the name of the new site
if the equipment moves in a cell on that same line. What I would like to do
is have the original cell be updated any time I type a new location in that
line. Any help would be appreciated.

text substitution
 

I tried your solution, but I get an error #VALUE!. I think this is because I
am looking to replace text and not a number. If you think I'm donig
something wrong in my formula, please let me know. thanks.

Also, do I need to be using "hlookup" since I'm using a row?

"Gary''s Student" wrote:

Let's say you want cell A1 to contain the most recent value in the first row.
So if we start with a value in B1, then we see that value in A1. If we
later enter a value in C1, then A1 changes to this value.

The desire is that A1 reflect he last (right-most) value in the row. In A1
enter:

=LOOKUP(2,1/($B$1:$IV$10),$B$1:$IV$1)

this should do the trick.
--
Gary''s Student - gsnu200802


"Mark" wrote:

I have a spread sheet that tracks equipment for our company. I split the
screen because I record fuel usage and meter readings on a number of pieces
of equipment. Part of the record indicates which of our project sites the
equipment is located at. At the beginning of the month, I type the site
location in a cell and as the month progress, I type the name of the new site
if the equipment moves in a cell on that same line. What I would like to do
is have the original cell be updated any time I type a new location in that
line. Any help would be appreciated.