Thread: Duplicates
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dias[_2_] Dias[_2_] is offline
external usenet poster
 
Posts: 6
Default Duplicates

Hi!
Thanks everyone, the simple formula from Max, works perfect for me.
Regards
Dias

Max escreveu:
You could select B1
or select col B (if you want it applied similarly for the entire col)

then Click Data Validation
Allow Custom
Formula: =COUNTIF(A:A,B1)<1
Click Ok

Test it out