markster
Well-known Member
- Joined
- May 23, 2002
- Messages
- 579
- Office Version
- 365
- Platform
- Windows
- MacOS
Hello
I need to get someone to enter data in a spreadsheet. They will be entering in column a. I need to fix it so the person entering the data cannot enter duplicate numbers so saying 1234 appears in cell a1, if they try to put the same number in in say a100 it won't let them.
Is this possible? and if so how?
Thanks
I need to get someone to enter data in a spreadsheet. They will be entering in column a. I need to fix it so the person entering the data cannot enter duplicate numbers so saying 1234 appears in cell a1, if they try to put the same number in in say a100 it won't let them.
Is this possible? and if so how?
Thanks