LinkBack URL
About LinkBacks
Hi.
I need to avoid duplicate data entry in the range of column "E".
by entering a value repeated the same should be automatically deleted.
Please Login or Register to view this content.
Hi.
I need to avoid duplicate data entry in the range of column "E".
by entering a value repeated the same should be automatically deleted.
Please Login or Register to view this content.
Last edited by marreco; 06-01-2012 at 07:34 AM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Hi
You can also do it, using in Custom Validation rules, this formula.
=COUNTIF(E:E,E1)=1
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I need via VBA, can you do?
then I will adapt into a form
thank you!!!
Ηι
You are welcome.
NO. I can't. I am not familiar with VBA. Sorry.
OK, thank you!!
Hi..
Any idea?
thank you!
Hi,
Here's a bit of code that may help you.
Tanking off for the evening. Good luck.Please Login or Register to view this content.
Charles
There are other ways to do this, this is but 1 !
Be Sure you thank those who helped.
IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.
I tested your code has something wrong, should be the criterion "sam". anyway I need to be based ..Please Login or Register to view this content.
Hi Marreco,
See if this does the trick:
Please Login or Register to view this content.
Last edited by xladept; 05-31-2012 at 10:18 PM.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hi.
Very good!!
Thank you!!!
Hi Marreco,
You're welcome! Maybe you ought to change:
toPlease Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks