1. In cell B1, input this formula: “=IF(ISERROR(MATCH(A1,$C$1:$C$13,0)),"",A1)”.
A1 is the column which you want to be compared.
$C$1:$C$13 is the range that you want to be compared with.
You can change the variables for what you are using.
2. Press the Enter key. Select cell B1, and then drag the fill handle over cell B15.
3. And all of the duplicate names will be displayed in column B. See screenshot:
No comments:
Post a Comment