Problem:
The range A2:C6 contains a list of items with their matching categories and prices.
Any rows containing identical entries are duplicate records.
We want to identify each duplicate record in the range.
Solution:
Use the SUMPRODUCT function as shown in the following formula:
=SUMPRODUCT((B2=$B$2:$B$6)*(A2=$A$2:$A$6)*(C2=$C$2:$C$6))>1
Bookmarks