No Duplicate Entries

[buz]

I have a dyn named DB with col D:D a numeric value that I want to eliminate the possibliity of duplicate entries. Is there a way to do this?

tfyh
Buz

 

[Aladin Akyurek]

Apply data validation with COUNTIF(Range,FirstCellRange)<=1 as formula.

 

[buz]

Looks like I have some studying to do re List Manager / Wizard - I'll see if I can figure this out

Thanks Aladin

 

[Todd Bardoni]

Just go to Data/Validation. In the Allow dropdown, select Custom. In the Formula box below that, type in Aladin's formula including the equal sign(don't forget to put in your range and your first cell reference.)

 

[buz]

tbardoni

thank you - I seem to be having trouble with it though.

The named range is MtrlData and the column where I do not want duplicate entries is D

I have tried =COUNTIF(MtrlData,D:D)<=1
and =COUNTIF(MtrlData,$D$2)<=1 (Row 1 is column headings)

Then typing in a duplicate entry produces no warning.

Had a thought and used COUNTIF(MtrlData,D:D)<=1 (no = in front) and now it works. Question now is: Where/How can i view the Data Validation formula/set up again? I'm not sure at this point whether I used D:D or $D$2 in the formula that is working.

 

[Aladin Akyurek]

...The named range is MtrlData and the column where I do not want duplicate entries is D...

Why do you bring in MtrlData? What range does it currently refer to? Is column D part of it?