Try

=INDEX(A:A,MATCH(REPT("Z",255),A:A))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Confused at Work" wrote in
message ...
FORMULA TRUBLE!!! I have 1 column with different words in it, then i have
a
sheet to track whats all the bins, I am trying to get the last item that
was
in the bin to appear automatically every time I put something else in the
bin. When i input it at the bottom then the last one will appear on the
other sheet. Can someone please help me its driving me crazy!!.