proficient
Well-known Member
- Joined
- Apr 10, 2012
- Messages
- 745
- Office Version
- 2016
- Platform
- Windows
- Mobile
Hi All, I am working on a sheet, there is a unique ID for all items mentioned in headers that are more than 30 (but I have mentioned some of them as example) and their status below them i.e dates (ETA) or IN-HOUSED (means item received). What I want you guys to do is that if items for a particular ID will arrive on same date like hang tag, poly bag, and jackron (belong to ID 1212) are arriving on 8-Oct and rivets and clips for same ID on 10-Oct so the formula or VBA code will show the outcome in cell I1 same as I manually put in I1. Hope it clears. see below chart for your ease. thanks in advance.
<tbody>
</tbody>
A1 | B1 | C1 | D1 | E1 | F1 | G1 | H1 | I1 |
ID | HANG TAG | CARTON | POLYBAG | JACKRON | BUTTTON | RIVETS | CLIP | RESULT |
1212 | 8-Oct | INHOUSED | 8-Oct | 8-Oct | INHOUSED | 10-Oct | 10-Oct | HANG TAG, POLYBAG, JACKRON 8-OCT, RIVETS, LIP 10-OCT |
1526 | 13-Oct | 13-Oct | 13-Oct | INHOUSED | 10-Oct | 9-Oct | INHOUSED | RIVET 9-OCT, BUTTTON 10-OCT, HANG TAG, CARTON, POLYBAG 13-OCT |
1684 | INHOUSED | 9-Oct | 8-Oct | INHOUSED | INHOUSED | 10-Oct | INHOUSED | POLYBAG, 8-OCT, CARTON 9-OCT, RIVETS 10-OCT |
<tbody>
</tbody>