Removing duplicates in Column B based on values in Column A

[gmalpani]

Hello Experts,

I have a worksheet with lot many rows and below is the mock data to represent the scenario.
I have below gives columns with headers - Opportunity No. and Feature (in original sheet there are 20 columns).
I have to remove duplicates in Feature Column but range to remove duplicates is dependent on Column - Opportunity No.

Here in e.g. there are two opportunities number - ABC12 and ABC50.
For ABC12, F2 is duplicate (row 3 and row 4) so remove one but it shouldn't remove F2 which belongs to different opportunity ABC50 given in last row.
So, range to find duplicates in Feature column shall be changed based on unique Opportunity no.

Opportunity No	Feature
ABC12	F1
ABC12	F2
ABC12	F2
ABC12	F4
ABC50	F5
ABC50	F6
ABC50	F7
ABC50	F8
ABC50	F9
ABC50	F2

Regards,
Gaurav

 

[Saba Sabaratnam]

Hi Gaurav,

I am not sure if I understand your question completely.

But, you can turn your range of data into Table and remove duplicates as shown below.

The table with no duplicates is shown below.

Kind regards

Saba

 

[gmalpani]

Thanks a lot .. this is what I was looking but I selected only one column.