Sir , ye to theek ki hum type kare to duplicates allow nahi karega but hum above value ko hi copy karke neeche paste karte hai ya cntrl d karte hai to duplicate entry ho jati hai. Aisa bataye copy paste bhi na ho paye.
"How To Stop Duplicate Values Entry in Excel in Hindi" Good day I learn so many thing from your videos but regarding this lesson we can't enter same value manually but we can enter the value by copy/paste and in this case duplicates are accepted. I am looking for the command which reject duplicate entries by any means. Is there a way, please show Thanks a lot
Vary Helpful video THANK YOU SIR
Very helpful thank you very much sir
Very helpful sir 👏 You made my life easier with this trick.
You earned a new subscriber😇
Ek 💗1 No. Sir jiiiiiiiiiii
Awesome 👍👍 Guruji
Amazing.
Sir , ye to theek ki hum type kare to duplicates allow nahi karega but hum above value ko hi copy karke neeche paste karte hai ya cntrl d karte hai to duplicate entry ho jati hai. Aisa bataye copy paste bhi na ho paye.
validation lagne k bad agr hum range me azafa karna chahye to ???
"How To Stop Duplicate Values Entry in Excel in Hindi"
Good day
I learn so many thing from your videos but regarding this lesson we can't enter same value manually but we can enter the value by copy/paste and in this case duplicates are accepted.
I am looking for the command which reject duplicate entries by any means.
Is there a way, please show
Thanks a lot
Good......
Welcome Dost
range lagane k bad dubara dekhni ho k range kaha tak lagi h to kase dekhy gye, agr phela se nai pta k range kha se kha tak hai?
now its working but if you copy and paste any no or text then sheet is taking the same
Thanks 👍
But whenever we doing copy paste or ctrl+D .....validation doesn't work. ..
hi sir its not working in my excel file. i am following the same formula as you suggested