» Identifying Duplicate Rows within a Range
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
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
Book Store:
No comments have been submitted.
