Removing duplicates in Column B based on values in Column A

gmalpani

New Member
Joined
Dec 24, 2011
Messages
33
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 NoFeature
ABC12F1
ABC12F2
ABC12F2
ABC12F4
ABC50F5
ABC50F6
ABC50F7
ABC50F8
ABC50F9
ABC50F2

Regards,
Gaurav
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Saba Sabaratnam

Board Regular
Joined
May 26, 2018
Messages
196
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.

1613047905220.png


The table with no duplicates is shown below.


1613047985603.png


Kind regards

Saba
 
Solution

Watch MrExcel Video

Forum statistics

Threads
1,127,830
Messages
5,627,145
Members
416,223
Latest member
RichardHell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top