FORMULAS

  • Thread starter Confused at Work
  • Start date
C

Confused at Work

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

Bob Phillips

Try

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top