View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yoli Yoli is offline
external usenet poster
 
Posts: 9
Default Preventing double entry formula

I am creating a phone list with telephone number for our employees to use
when they are calling our clients. I want to prevent a phone number being
entered on the call list multiple times. Is there a way that I can enter a
formula that will give me either a stop or warning message when a phone
number is already on my spread sheet? Please Help.
--
Yoli