View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default I want to secure a column from have the same number entered twice

I have a spreadsheet running that includes the scanning of a serial reference
number containing text and numbers on software. I need to secure that column
to prevent duplicate numbers being scanned and entered into the sreadsheet.
This then preventing dupilcate serial numbers being attached to software
before shipping. I've looked at condition formats and validation but can't
see the way forward yet.