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...