IN EXCEL, HOW CAN I TYPE IN NUMBERS AND HAVE THEM NOT REPEAT?

[LLoana]

Im working on a spreadsheet and I want to be able to type in all the numbers
and then have a formula to get rid of duplicate numbers

[Bernard Liengme]

see lots of stuff on duplicates at www.cpearson.com
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"LLoana" <LLoana@discussions.microsoft.com> wrote in message
news:4E404CC0-F646-4EB1-8D5F-A4B00AE1BE5B@microsoft.com...
> Im working on a spreadsheet and I want to be able to type in all the
> numbers
> and then have a formula to get rid of duplicate numbers