Dear All,

Please i need the formula for colum D Status, it can display Pickcal or In
or Out or Picked.

Colum A Colum B Colum C Colum D
Confirm Date scanin scanout Status

Pickcal
17-03-10 11:38 In
17-03-10 11:38 17-03-10 11:49 Out
17-03-10 11:25 17-03-10 7:29 17-03-10 8:24 Picked
17-03-10 11:20 Picked


Thans so much.
Tran1728