Excel: Flag Duplicate IDs
Flag every ID that occurs more than once.
Before you answer
State the key, the expected grain and one edge case you would test. The goal is not only to get a result, but to know why it is correct.
Hint
COUNTIF($A:$A,A2)>1.
Completion is stored only in this browser.