Remove duplicates looking at values in other column

Status
Not open for further replies.

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

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Kerryx

Board Regular
Joined
May 6, 2016
Messages
101
if you set up a help column and concat the Opp & feature and use this to remove duplicates would this do?
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,127,832
Messages
5,627,150
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