Thanks Max, you have sorted all my problems thank you.

"Max" wrote:

"BER" wrote:
Thanks Max that is great when entering new data it certainly works, now can
you help me to check the entries already there to see if there are duplicates
there already

One way ..

Assuming existing names running in A2 down,
using an empty col to the right, say col E

Put in E2:
=IF(COUNTIF($A$2:A2,A2)1,"Dup","")
Copy down

This will flag duplicate names within col A if any, with the text: Dup in
col E

Then you could do a data filter autofilter on col E,
and select "Dup" from the autofilter droplist in E1
to filter out all the duplicates for closer inspection ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---