You can't use COUNTIF to remove duplicates, you will need to filter the
source using DataFilterAdvanced Filter with Unique Records checked and
Filter in Place.

--
HTH

Bob Phillips

"andrewm" wrote in
message ...

Hi - I am using data validation list to create a list. I would like to
in the same cells use data validation custom with countif to limit
duplicates. what can I do. I do not really want to use vba if I don't
have to.any suggestions and can someone point to me to the right
direction

andrewm


--
andrewm
------------------------------------------------------------------------
andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
View this thread: http://www.excelforum.com/showthread...hreadid=381560