Please see the picture below:
COUNTIF(A$2:A$7, $B2) > 0
Return : True or False
Explain:
Compare the value between (A2 to A7) and B2, count the number if duplicated.
If the count is bigger than 0, return True.
If not, then return false.
IF(..... , "Duplicated", "")
Return : "Duplicated" or ""
Explain:
If the formula returns true, then shows "duplicated" in the cell
if not, shows nothing.
Really simple !
No comments:
Post a Comment