Excel tip - search for duplicates

Here is a function that returns TRUE or FALSE if it finds duplicates for A1 cell in the A1:A200 interval:

=COUNTIF($a$1:$a$200;a1)=1