Remove duplicates looking at values in other column

[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

 

[Kerryx]

if you set up a help column and concat the Opp & feature and use this to remove duplicates would this do?

 

[Fluff]

Duplicate to: Removing duplicates in Column B based on values in Column A

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.