in D3 (Assuming that is the 2nd row of data in your list, acoounting for a
title row), type:
=IF(A3=A2,"Y","N")

This will palce a y in the D Col next to any repeating values in the A column.

Hope this helps.

"Kimbor" wrote:

Howdy! I have a large, but simple, database list consisting of three columns
-- first name, last name, email -- that I've sorted by last name. I'm
looking for a formula that will find the duplicates and highlight them for
me. It sounds simple, but I just can't figure it out. Anyone? Thanks!