Forum Discussion

Dustnewell's avatar
Dustnewell
Copper Contributor
Feb 13, 2024

Remove Duplicates depending on other cell

Hello,

 

I have 3 columns. For all of the values in column A that have the same value i want to look at the matching values in column b and c. Of those, for each individual value in column b i want to remove the duplicates in column c. Is this possible? Thank you in advance.

excel

1 Reply

  • rachel's avatar
    rachel
    Iron Contributor
    Feb 14, 2024

    Dustnewell 

    Hi,

     

    Are you saying an entry can only be counted as "Duplicates" when all three columns (A, B, C) are exactly the same?

    If so, I think you can use UNIQUE to remove duplicates:

     

     

Resources