Forum Discussion
Dustnewell
Feb 13, 2024Copper Contributor
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...
rachel
Feb 14, 2024Steel Contributor
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: