Excel Custom Data Validation | Use formula to check for Weekend , Leadspace ,NoSpace ,Duplicate

[@sandeepaswal8944]

Namstai sir ji. Aaaj kai topic mai new shikhnai ko mila. Practice karkai maja aagaya. Aap jaisai teacher nahi dekha mainai. Aapnai muje nayi disha di hai.

[@Innozant]

Thanks Sandeep ji👍❤️Love you dear.🙂

[@निखिलदेसले]

सर आपके वजह से हि मै इंटरव्ह्यू crack कर पाया thanxquee so much sir.. for all video love u so much....i am bigest fan of you. आपके पढाने तरीका हि ऐसा है कि nothing is impossible in excel ऐसा लगता है

[@Innozant]

Thanks Nikhil Ji..God bless You .Seekhte rhiye aur life me humesha aage badhiye

[@निखिलदेसले]

@@Innozant हा सर मैंने basic excel, advance filter n conditional formatting yeh 3 playlist complete kiya aage bhi dhire dhire complete kar ke mujhe dash board reporting tak jaana hai

[@Innozant]

Good

[@LetsLearnEnglish-tk9sw]

​@@निखिलदेसलेbhaiya kaun si job kr rahe ho aap

[@puransingh-sx2tk]

Har roj kuch naya sikhane k liye dil se shukriya guru g ❤️👌🏻

[@Innozant]

Thanks Puran 🙏❤️👍

[@lorenzoelise3121]

Okays let me explain it in different way for example if I have a data with 2000 row and 15 columns now what i want to show all the data which are containing less (for example d4

[@Innozant]

@@lorenzoelise3121 Ok Will connect with you live via zoom on weekend for a while and try to understand and solve your query for the same.

[@satishojha6240]

Data validation ke concept clear ho rahe hai sir thanku very much 🙏🙏🙏

[@Innozant]

Thanks Satish Ji🙏❤️

[@shaileshkumar-qf6bd]

Apka task to mind blowing hai sir and teaching style bhi🙏🙏

[@Innozant]

Thanks Shailesh Jii..Keep learning ❤️

[@Learn_withkd]

Very informative Sir 👍👍👍

[@ghumansaab2314]

Very helpful validation series sir👍

[@Innozant]

Thanks Ghuman Sahab🙏❤️👍

[@ArmanKhan-iq3ji]

Wow Sir ji this function will work on my data thanks for sharing this wonderful video 👍

[@Innozant]

Good... Thanks Arman. do Practice ok daily basis .❤️❤️🙏

[@msexcelgooglesheet374]

Superb Series of Data Validation Awesome, Sir ji 🙏.

[@Innozant]

Thanks .. Happy Learning..Share and Support dear 🙏♥️

[@FarhadManik]

Awesome classes sir

[@pramodbhavsar4488]

Very nice new formula tricks for custom datavalidation thank you sir

[@Innozant]

Thanks Pramod Ji.Keep Supporrting 🙏👍❤️

[@Emanzvlogs]

Fantastic video ,plz guide to prevent duplicate entry in rows of a sheet at multiple columns

[@Innozant]

You want to sef constraint via data validation ?

[@kinghundred]

very good sir

[@hemantgusain1260]

Really helpful video.

[@Innozant]

Thanks Hemant.🙂🙏❤️

[@dhakafady774]

THANKS A LOT SIR

[@sanjogbarathe285]

Thank you so much 🙏🙏🙏🙏

[@Innozant]

Thanks Sanjog...❤️🙏

[@dipaksutradhar4404]

Sir aapke channel se bhat kuch sikne mil raha hai ek request hai pls playlist delete mat kijiye ga quki kuch problem hota hai to aapke video se help mil jata hai

[@Innozant]

Thanks Dipak .Playlis delete kyu krenege dear..aapka hai ye channel..padhiye aur life me aage badhte rhiye

[@uniquemobiletipstricks7714]

Mind blowing

[@naeemkhan-tm9hx]

Nice

[@shrikantbadge3978]

Thank you sir

[@zzzzz644]

At 07:49 in video, don't understand as you said NO DUPLICATES with MULTIPLE CRITERIA. But as in TABLE in video has duplicates, and also after downloading this file has duplicates even after DATA VALIDATION being applied. Wanted to know how to apply this in DATA VALIDATION????

[@praveenthakare8357]

Drop down copy hone ke bad sirf value copy hona chahiye kya aaisa ho sakta hai

[@lorenzoelise3121]

Dear sir i have a table about product with different cities, product order, product despatch and shortages about products all are in digits simple formula is that (order-despatch) and through this i can see shortage. What i want to display shortages with complete row including cities, order, despatch with shortages on diffent table on different colum and row. Means excel pick all cities with only shortages and transfer to another sheet along with all coluns. Looking forward to hear from you

[@Innozant]

Share your worksheet format with query explanation.Will see it and respond you for the same.

[@amandeepbadgujjar7096]

Hi good evening sir I hope you well and healthy, sir mera ek question h, sir me jab bhi table me value pass karta hu $ ke sath to vo value text ban jati h, me thik bhi karta hu jese apne bataya tha shortcut alt+d+e+f sir phir bhi nhi hota koi solution ha sir ya me galti kar raha hu value pass karne me? Repl😇😇

[@sangamsah2373]

Sir data validation me example ke liye agar shell A1 me text Pen likha ho to shell B1 me value 10 se jyada na aaye or agar shell A1 main hi Notebook likha ho to Shell B1 me value 50 se jyada na aaye. Need formula🙏

[@imranibrahim8247]

SIR, I have multiple supplier names in range, want to make drop down list only for unique name I used formula unique but its not working Please help on this

[@V2000-c6h]

Sir in data validation box when i am trying to put countif and countifs formula with naming range it's not working?

[@MyChannel-zf7lg]

Sir, agar hamare pass ek product ka 3 sub product ho aur side me wuska drop down list me jo sub prouct select karu waska 1st large aur 2nd large kaise laye...pls help me.

[@Innozant]

Validation constraint me laga dijiye formula large aur cell ref ke jagah drop down wala address select kariye

[@meriawaazhindi5217]

❤️❤️❤️❤️❤️

[@adnanshoukat807]

nice sir g

[@Innozant]

Thanks Adnan Shahab🙏❤️

[@gauravbhatia7987]

Good

[@Innozant]

Thanks Gaurav.. Happy Learning 🙏❤️

[@tjr1421]

Sir first example me mene "And" wala formula lagaya, but sir mene sat n sun ka date type kiya to b accept kar raha hai.I type the same formula u showed in video, it's not showing any error?

[@tjr1421]

Got it sir. I was typing date in format dd-mm-yyyy, but it's accepting in format mm-dd-yyyy.😁 Ye choti choti cheeze b mayne rakhti hai.🙏

[@avanishchandra3795]

Sir cell me unique value one cell me example...1234,5678. Isme value repeat nahi ho raha hai agar hua tho error aa jaye

[@Innozant]

Matlab .. explain kijiye dubara 🙏

[@ghumansaab2314]

Sir agar ek cell me (33+5) do number ka sum kaise kar sakte hai ??

[@Innozant]

Question nhi Aaya samajh ,ek Baar explain kriye kya karna chahte Hain aap

[@ghumansaab2314]

@@Innozant I mean ek hi cell me 2+2 value is trah se likhi ho to us cell ka sum =4 is trah se karna ho to kaise kare gy

[@mohitsharma-ym3km]

Sir custom me formula ka result true ya false hona chahiye but aapne =trim(A1) se kaise Kiya. Kyunki ye logical test to nhi hai. Please reply

[@Innozant]

Kaunse Question me ? Mohit Ji

[@mohitsharma-ym3km]

@@Innozant condition is To allow Only those text which has no leading, training and extra spaces. Is waale question me Sir

[@ramyakudikala8117]

Sir formulas we can't entering Show us formulas as big

[@Innozant]

Didn't get you Ramya,kindly explain

[@suhaibali3974]

Sir kuch formulas work nhi kr rhe h

[@mohd.zeeshan8581]

Data Validation m countiifs formula work nhi kr rha hai

[@Innozant]

Kya chahte h output

[@mohd.zeeshan8581]

@@Innozant Sir Data Validation m maine double criteria lagaya countifs s wo work nhi kr rha

[@jyotinayak8505]

Same problm i m facing also..=COUNTIF($A$1:$A$10,A????)=1..kaam nei kar raha ...eshe aur ek example b tha..vo b kam nei kar raha he

[@VLAXIN]

sir i am your big fan but i search in many videos I tried many foumulas but I can't find solution of dropdown list without duplicates from another table. (In office 2016).🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

[@Learn_withkd]

Very informative Sir 👍👍👍👍