Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULAS
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!!. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULAS
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!!. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif formulas change after doing a sort | Excel Worksheet Functions | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |