Data Validation - Number, Length and no Duplicates

Hi Guru's,

A few years ago the below formula/answer was posted and it worked great.
This did data validation to ensure the cells had 6 digits and it was not duplicated in that column.

Originally Posted by Haseeb A

Hello,

Assume decimals also not allowed. try this;

=AND(INT(A1+0)=A1+0,LEN(A1)=6,COUNTIF(A$1:A1,A1)<=1)

I would now like to expand on this a little if possible, i would now like my data validation to only allow numbers?


The rule should be:

• Must be 6 digits in length
• No duplicates in that column
• Must be numeric

Can you help with this please?

Regards,
Jamie

That's got it!

Thank you very much