If you need to find the duplicated data in two group of items, just list them in two column in Excel. Place them in Column A and C. Then in column B, use this formula to find which data in column A is the duplicated one.
=IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1)
The formula above is meant for 5 items.
If you have 100 data in column C, just change the $C$5 value to $C$100.
No comments:
Post a Comment