View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wanna Learn Wanna Learn is offline
external usenet poster
 
Posts: 318
Default do not repeat numbers in a column

Hello I have a spreadsheet with agent numbers-over 400) each number
should be unique. I cannot use random because I do not want to change the
numbers of the existing agent number. Is there a formula that would tell me
if a number already exist in the column - Numbers must be random thanks