Libre office calc

Find duplicates in a column:

=if(countif(e$4:e$9;e4>1;"Yes!";"No")

Adapted from: Askubuntu & Techrepublic.