Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do I ensure

  1. only integers
  2. with no duplicated values

can appear in a column in Excel 2007?

share|improve this question

You check for duplicated values using something similar to the answers received in your question yesterday, then also check that the value is an integer.

Using A as the column, select A2 through as far in column A as you care about, then go to the Data Validation dialog. Choose custom and input the following formula:

=IF(ISNA(VLOOKUP(A2,A$1:A1,1,FALSE)),IF(INT(A2)=A2,TRUE,FALSE),FALSE)

As someone mentioned in your other question, this will only work for input values, not dragged ones.

NOTE: The standard column choosing method of A:A doesn't appear to work in this scenario because apparently the code always sees the cell itself as a duplicate (of itself), so it always fails.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .