ExcelBanter - unique number

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - unique number (https://www.excelbanter.com/excel-discussion-misc-queries/239906-unique-number.html)

BABYPINK

unique number

Hi

I need to enter unique numbers (Manually) into a column

I just want to make sure there are no duplicates, the format is

SA123456
SA365489
SA222222

Hopefully if I do enter a duplicate the column will not let me

Thanks

Bob Phillips[_3_]

unique number

Use data validation type custom with a formula of

=COUNTIF(A:A,A1)=1

--
__________________________________
HTH

Bob

"BABYPINK" wrote in message
...
Hi

I need to enter unique numbers (Manually) into a column

I just want to make sure there are no duplicates, the format is

SA123456
SA365489
SA222222

Hopefully if I do enter a duplicate the column will not let me

Thanks

Eduardo

unique number

Hi,
look into CPearson web

http://www.cpearson.com/excel/NoDupEntry.aspx

if this helps please click yes, thanks

"BABYPINK" wrote:

Hi

I need to enter unique numbers (Manually) into a column

I just want to make sure there are no duplicates, the format is

SA123456
SA365489
SA222222

Hopefully if I do enter a duplicate the column will not let me

Thanks

All times are GMT +1. The time now is 09:07 PM.