No repeats of name in same colum

  • Thread starter Thread starter Headworth
  • Start date Start date
Hi,

Select your range which in my case is A1 - A40 and then
Data|Validation|Custom

enter the formula

=COUNTIF($A$1:$A$40,A1)=1

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Jululian 2
List of Id's in one Colum list of names in another. More Id's on s 1
alphabetical order in a colume 1
Function for count a list of repeatitive names 2
link colums 1
Cannot tab from colum to colum 4
Text to Colums 1
Hiding colums when saving as html 4

Back
Top