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.
[TABLE="width: 1280"]
<tbody>[TR]
[TD]A1[/TD]
[TD]B1[/TD]
[TD]C1[/TD]
[TD]D1[/TD]
[TD]E1[/TD]
[TD]F1[/TD]
[TD]G1[/TD]
[TD]H1[/TD]
[TD]I1[/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]HANG TAG[/TD]
[TD]CARTON[/TD]
[TD]POLYBAG[/TD]
[TD]JACKRON[/TD]
[TD]BUTTTON[/TD]
[TD]RIVETS[/TD]
[TD]CLIP[/TD]
[TD]RESULT[/TD]
[/TR]
[TR]
[TD]1212[/TD]
[TD]8-Oct[/TD]
[TD]INHOUSED[/TD]
[TD]8-Oct[/TD]
[TD]8-Oct[/TD]
[TD]INHOUSED[/TD]
[TD]10-Oct[/TD]
[TD]10-Oct[/TD]
[TD]HANG TAG, POLYBAG, JACKRON 8-OCT, RIVETS, LIP 10-OCT[/TD]
[/TR]
[TR]
[TD]1526[/TD]
[TD]13-Oct[/TD]
[TD]13-Oct[/TD]
[TD]13-Oct[/TD]
[TD]INHOUSED[/TD]
[TD]10-Oct[/TD]
[TD]9-Oct[/TD]
[TD]INHOUSED[/TD]
[TD]RIVET 9-OCT, BUTTTON 10-OCT, HANG TAG, CARTON, POLYBAG 13-OCT[/TD]
[/TR]
[TR]
[TD]1684[/TD]
[TD]INHOUSED[/TD]
[TD]9-Oct[/TD]
[TD]8-Oct[/TD]
[TD]INHOUSED[/TD]
[TD]INHOUSED[/TD]
[TD]10-Oct[/TD]
[TD]INHOUSED[/TD]
[TD]POLYBAG, 8-OCT, CARTON 9-OCT, RIVETS 10-OCT[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1280"]
<tbody>[TR]
[TD]A1[/TD]
[TD]B1[/TD]
[TD]C1[/TD]
[TD]D1[/TD]
[TD]E1[/TD]
[TD]F1[/TD]
[TD]G1[/TD]
[TD]H1[/TD]
[TD]I1[/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]HANG TAG[/TD]
[TD]CARTON[/TD]
[TD]POLYBAG[/TD]
[TD]JACKRON[/TD]
[TD]BUTTTON[/TD]
[TD]RIVETS[/TD]
[TD]CLIP[/TD]
[TD]RESULT[/TD]
[/TR]
[TR]
[TD]1212[/TD]
[TD]8-Oct[/TD]
[TD]INHOUSED[/TD]
[TD]8-Oct[/TD]
[TD]8-Oct[/TD]
[TD]INHOUSED[/TD]
[TD]10-Oct[/TD]
[TD]10-Oct[/TD]
[TD]HANG TAG, POLYBAG, JACKRON 8-OCT, RIVETS, LIP 10-OCT[/TD]
[/TR]
[TR]
[TD]1526[/TD]
[TD]13-Oct[/TD]
[TD]13-Oct[/TD]
[TD]13-Oct[/TD]
[TD]INHOUSED[/TD]
[TD]10-Oct[/TD]
[TD]9-Oct[/TD]
[TD]INHOUSED[/TD]
[TD]RIVET 9-OCT, BUTTTON 10-OCT, HANG TAG, CARTON, POLYBAG 13-OCT[/TD]
[/TR]
[TR]
[TD]1684[/TD]
[TD]INHOUSED[/TD]
[TD]9-Oct[/TD]
[TD]8-Oct[/TD]
[TD]INHOUSED[/TD]
[TD]INHOUSED[/TD]
[TD]10-Oct[/TD]
[TD]INHOUSED[/TD]
[TD]POLYBAG, 8-OCT, CARTON 9-OCT, RIVETS 10-OCT[/TD]
[/TR]
</tbody>[/TABLE]