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 duplicate number

Hello I have a long spreadsheet that has a column with extension numbers. I
do not want the same extension to be entered twice , (not 2 people can have
the same extension number) Is it possible to have an error message pop up
when a duplicate extension number is entered in the spreadsheet? I have
excel 2002 thanks in advance