Hi, sir, thanks a lot. now I got a question.
to prevent duplicate entries in my excel sheet, i used data validation to to set COUNTIF($A$1:$A$14,A1)=1
but I need to entry same number twice now, how should I just type this entry twice and remian other engry still unique?
Thank you so much for your kindly help
the 1st thought that comes to mind is to remove DV from that specific cell?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
http://www.excelforum.com/excel-form...-function.html
Thread Closed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks