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
|