I run a trailer log through a worksheet and sometimes the same trailer number gets entered in two different locations. Is there a way to stop letting people enter the same number twice on a spreadsheet?
I run a trailer log through a worksheet and sometimes the same trailer number gets entered in two different locations. Is there a way to stop letting people enter the same number twice on a spreadsheet?
I am using excel 2003 if that makes a difference.
This is dependent on what cells you want to prevent duplicates in. Lets say the range is cells A1:A50. Follow these steps:
1. Click on Cell A1 and drag down to A50, highlighting the range.
2. Go to DATA in the main menu toolbar, then select VALIDATION.
3. Note the allow: dropdown box. Select CUSTOM.
4. In the formula toolbar, enter this formula: =COUNTIF($A$1:$A$50,A1)=1
Now, if someone tries enterring the same number in two separate cells, an error message will appear.
Try it and let me know if it works.
That worked, thankyou so much for the quick response.
Happy to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks