Comparing a column of names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to have an error message occur if the same name is used more than once
in that column. Is there a function or set of functions that I could use to
do that?
 
What does "used more than once" mean?

Does that mean entered into only one cell in a range of cells?

If that's the case you can use data validation for this.

Assume you enter the names in the range A1:A10 and you do not want any
duplicates.

Select the range A1:A10
Goto the menu Data>Validation
Select Custom
Formula:

=COUNTIF(A$1:A$10,A1)<=1

Biff
 
You must log in or register to reply here.

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 Comparing two columns 1
Invalid Column Name Sql-Error :Executing a stored procedure 1
Comparing Text between Columns 6
compare 5 columns of text and highlight duplicates based on repeti 2
comparing columns in two spreadsheets 1
Comparing text within cells in two columns 2
If, Or function or macro to compare 3 columns of numbers 3
Comparing/Matching two columns 4

Back
Top