software

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!!.

Try

=INDEX(A:A,MATCH(REPT(quot;Zquot;,255),A:A))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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