Remove Duplicates depending on other cell

Copper Contributor

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.

1 Reply

@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:

Screenshot 2024-02-14 at 12.38.57 PM.png