Forum Discussion
Solved
Comparing Duplicates in Column A with Duplicates in Column B
Hello! I'm hoping there's a way to do this but I haven't figured it out yet so any help would be greatly appreciated. I have two columns of data which have duplicate values in: Fruit Quanti...
I solved it using the following formula:
=AND(COUNTIFS($A$2:$A$11,A2,$B$2:$B$11,B2)>1,C2="Primary")Thanks for the help everyone!
I returned the result because Apple is the only fruit not to feature in multiple distinct records.
= LET(
FruitFreq, COUNTIFS(Fruit, Fruit),
RecordFreq, COUNTIFS(Fruit, Fruit, Quantity, Quantity),
UNIQUE(FILTER(Data, RecordFreq=FruitFreq))
)