View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Glint Glint is offline
external usenet poster
 
Posts: 6
Default AVOIDING DUPLICATES IN A RANGE OF CELLS

Hi Everyone,
I am very new to Excel and I need to enter a series of figures into a range
of cells, say 1 to 400. How do I ensure that:

a) only figures are accepted, and must be between 1 & 400
b) the figures are not duplicated?

Thanks for your assistance.
--
Glint