Hi!

Take your pick:

If the data is numeric:

=LOOKUP(MAX(A1:Z1)+1,A1:Z1)

If the data is text:

=LOOKUP(REPT("z",255),A1:Z1)

If the data is mixed:

=LOOKUP(2,1/(A1:Z1<""),A1:Z1)

Biff

"Carolyn Bennett" <Carolyn wrote in
message ...
I am creating a document where I want excel to seach along a row and find
the
last entry (the cell with information on the far right of the row). This
information will change constantly, and I will need excel to keep check
for
new entries to the right of it.