Home |
Search |
Today's Posts |
#1
|
|||
|
|||
no duplicate numbers
I have 100 numbers (1-100) that are tickets. Since you really can't trust anyone i want to make something that won't let you use the same number twice. so if i use ticket number 57 and made copies then the next person to come up w/ ticket 57 when entered into the computer would get an error message. Also if possible i would like it to inprint the date and time when it moves it. So i was thinking like cell a1 is empty and then you press enter (on say a button) it would move the number to a different part of the sheet and tag it w/ the date and time. i just can't get the macro to work that won't let me use the same nubmer twice. Any ideas? -- Neuther ------------------------------------------------------------------------ Neuther's Profile: http://www.excelforum.com/member.php...fo&userid=4688 View this thread: http://www.excelforum.com/showthread...hreadid=474421 |
#2
|
|||
|
|||
Neuther Wrote: I have 100 numbers (1-100) that are tickets. Since you really can't trust anyone i want to make something that won't let you use the same number twice. so if i use ticket number 57 and made copies then the next person to come up w/ ticket 57 when entered into the computer would get an error message. Also if possible i would like it to inprint the date and time when it moves it. So i was thinking like cell a1 is empty and then you press enter (on say a button) it would move the number to a different part of the sheet and tag it w/ the date and time. i just can't get the macro to work that won't let me use the same nubmer twice. Any ideas? To prevent duplicate entries in a column 1. Select a range where entries will be made (e.g., Cells A1:A100) 2. Go to Data/Validation/Custom 3. Enter this formula =countif($A$1:A100,A1)=1 4. Select "Error Alert" tab and enter any appropriate message Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=474421 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find duplicate cells in large array of numbers | Excel Worksheet Functions | |||
search to identify duplicate enties in long columns of numbers | Excel Discussion (Misc queries) | |||
prevent duplicate entry for range of numbers 00001 to 99999 in ex. | Excel Discussion (Misc queries) | |||
How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
Add numbers for duplicate entries then delete | Excel Worksheet Functions |