EdCarryhands
New Member
- Joined
- Apr 15, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi All,
Please help me with this.
I have a sheet with Column A(ID e.g. 1111-2222-3333-4444) and Column B(Status e.g. Installed, Inactive, Cancelled).
It has several duplicates on both columns. My goal is to have only one ID and if there is Installed status amongst the duplicates it has to be it. It is possible that 2 duplicates both Inactive then 1 has to be deleted. Also some IDs are duplicated 3,4, even 5 times.
Do you guys have any idea?
Thanks in advance.
Please help me with this.
I have a sheet with Column A(ID e.g. 1111-2222-3333-4444) and Column B(Status e.g. Installed, Inactive, Cancelled).
It has several duplicates on both columns. My goal is to have only one ID and if there is Installed status amongst the duplicates it has to be it. It is possible that 2 duplicates both Inactive then 1 has to be deleted. Also some IDs are duplicated 3,4, even 5 times.
Do you guys have any idea?
Thanks in advance.