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