View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
delmac delmac is offline
external usenet poster
 
Posts: 30
Default validating data in acolumn

Hi all, I've got a column of invoice numbers and each time I add one I want
to make sure it it is not duplicated. I've tried using a function with
copy/paste validation, but it doesn't always work as the invoices can be text
as well as number. Any ideas. Thanks very much.
--
delmac