Duplicate Numbers

  • Thread starter Thread starter Joe Newlin
  • Start date Start date
J

Joe Newlin

I want to have a column that can not have a number entered into it if that
number exist in another cell in that column.
 
Maybe you could use Data|Validation.

Select your column (I used column E), then
Data|validation
Allow: Custom
Formula: =COUNTIF(E:E,E1)<2

(E1 was my activecell.)
 
Joe
Here is some good stuff from Debra.
From Debra Dalgleish
If your order numbers are in column A, with a heading in row 1:
1. Select cells A2:A50 (or to the end of your entry range)
2. Choose Data>Validation
3. Choose Allow:Custom
4. In the formula box, type a formula that counts the entries above,
that match the active cell:
=COUNTIF(A$1:A1,A2)=0
5. Click OK
Keep in mind that Data Validation is not foolproof -- users can copy and
paste invalid numbers into the cells.

HTH Otto
 
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

How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
Conditional formatting 9
VLOOKUP forumla for Excel HELP! 1
counting formula 3
Can't Explain N/A in Vlookup 2
Highlight a cell that is a duplicate 1
lookup and return column number 2
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3

Back
Top