Excel wildcard trick for 2020 || Excel trick in hindi 2020

#Excel #wildcard trick for 2020 , app new #exceltricks and tips seekh sakate hai aur wild card ka best use kese kar sakte hai aap is video ke madhayam se seekh sakte hai..
*****************
Download link :- drive.google.c...
**********************
Don't forget to subscribe my channel get more related video notification. SUBSCRIBE - / @gyanontube
****************************FOLLOW ON************************
Facebook :- / excelworldofknowledge
Twitter - / sohandey3
KZbin- / @gyanontube
Follow me on Instagram :- / gyan_on_tube
___________________
How to use Xlookup in excel 😮 || xlookup formula in hindi 😮|| vlookup formula in excel :- • How to use Xlookup in ...
Array formula excel || array function in excel || Excel Vlookup ❌|| index Match Excel ❌ :- • Array formula excel ||...
xlookup in excel in hindi || Xlookup A to Z in details || New Xlookup with Search Mode :- • xlookup in excel in hi...
Xmatch formula in excel || Xmatch formula in excel in hindi || Xmatch with Index formula:- • Xmatch formula in exce...
filter formula in excel || how to use filter formula in excel in hindi 😮 filter formula in hindi :- • filter formula in exce...
Top 10 excel formulas 😮|| excel formulas and functions || excel functions and formulas :- • Top 10 excel formulas ...
How to use excel unique function || Excel unique formula in hindi || Remove duplicate values:- • How to use excel uniqu...
Drill Down in Pivot table excel || Classic Pivot table view in hindi :- • Drill Down in Pivot ta...
3D Pivot Graph in excel in hindi || Lean Pivot from beginner to advanced || lean pivot table:- • 3D Pivot Graph in exce...
excel slicer || how to use pivot table slicer || slicer in excel 2007 and above :- • excel slicer || how to...
advanced pivot tables || advanced pivot table excel || IF formula in Pivot :- • advanced pivot tables ...
Sort formula in excel || array formula in excel || how to use sort formula in excel :- • Sort formula in excel ...
share excel workbook || excel shared workbook || excel tips and tricks :- • share excel workbook |...
pdf to word || convert word to pdf || ❌No software ❌No online convert pdf to word ***FREE** 😮 :- • pdf to word || convert...
Array formula excel || array function in excel || Excel Vlookup ❌|| index Match Excel ❌ :- • Array formula excel ||...
interview questions and answers || interview questions || advanced Excel || Excel Interview #7 :- • interview questions an...
google translate :- google translate english to hindi :- google translate in hindi :- • google translate :- go...
advanced excel :- Top 5 Advanced excel and word tips and tricks :- excel formulas in hindi :- • advanced excel :- Top ...
Job Interviews question !! Excel interview question in Hindi !! Job Interviews question part 3 :- • Job Interview Question...
Job Interviews question !! Excel interview question in Hindi !! Job Interviews question part 2 :- • Job Interviews questio...
Excel Interview Question 😮 MIS Interview Question in Excel in Hindi 😮 Excel Interview :- • Excel Interview Questi...
3D Glass Chart in hindi 😮 3D graph in hindi 😮 3D Excel Graph :- • 3D Glass Chart in hind...
Interview question how to get first and last name in excel 😮 First and Last name in Excel in Hindi. :- • Interview question how...
Serial Number auto populate 😮सीरियल नंबर औटो पॉपुलटे कैसे करें 😮rows formula to populate serial no :- • Serial Number auto pop...
Nested IF V/S IFS 2019 !! 😮😮 How to use IFS formula 2019 with Nested IF :- • Nested IF V/S IFS 2019...
Fuzzy Lookup in hindi !! how to use fuzzy lookup in excel in hindi.😮😮:- • #Fuzzy Lookup in hindi...
How to Hide formula in Excel in Hindi 2019 😮😮!! Formula hide in Excel 2019 😮 :- • How to Hide formula in...
Window 10 Top hidden tricks 2019 👍 Windows 10 tricks 😮Windows 10 Hidden Features :- • Window 10 Top hidden t...
How to Change Excel background color In hindi ! office 2019 :- • How to Change Excel ba...
Advance Excel - Top 5 Excel Time Saving tricks 2018-2019 :-
• Advance Excel - Top 5 ...
Useful Excel trick for Biggner and Expert :-
• Useful Excel trick for...
How to Separate all text available in a cell :-
• How to Separate all te...
Macro Coding for Auto-fit cells in Excel :-
• Macro Coding for Auto-...
One Vlookup Multiple Worksheets :-
• vlookup in excel !! बह...
How to unlock Protected Excel sheet without Password :-
• How to unlock Protecte...
INDIRECT with Sum formula in Excel :-
• INDIRECT with Sum form...
*************************************(Gyan On Tube)********************************

[@rajivroy4708]

Sir aaj ki class bahut achha tha thanks sir

[@GyanOnTube]

Thank you so much

[@chganesh3775]

Interesting trick today I have learned.

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@deepakkeshari1168]

Very powerful video thanks sir

[@GyanOnTube]

Deepak ji....aap ke comment ke liye sukriya..keep sharing keep learning

[@onlyexcel493]

Ese he basic video dekhne me bahut mja aata he sir

[@GyanOnTube]

Nileshgiri goswami ji bus aap logo ke itne ache ache comment ke liye hi esi videos banane ka support milta hai..

[@javedahmed8343]

Excellent explanation with formula

[@GyanOnTube]

Thank you so much

[@deepakkeshari1168]

Sir, apne sahi kaha work kar raha he

[@GyanOnTube]

Thank you so much

[@bharatsinghrathor3082]

Awesome aur unique topics or video banaate ho aap... Aur aapki Sabse achi baat ...maine first time dekha hai koi you tuber har comment pe proper reply kar Raha hai...

[@GyanOnTube]

Bharat singh Rathor ji..thank you so much for your valuable comment..bus mujhe ek bat pata hai mein aaj yaha hu to sirf aap logo ke waja se hu..so i value all my subscriber very very much..true respect for you all 🙏..

[@onlyexcel493]

Really sir ye video hamare liye beneficial rha

[@GyanOnTube]

Nileshgiri goswami ji keep sharing my videos bus aap logo ka pyar aur support chaiye

[@onlyexcel493]

Definitely

[@manthan746]

Your voice tone is excellent,and apka smjhana ekdm mst h 🔥🔥🔥🔥🔥

[@GyanOnTube]

Thank you so much..do not forget to share this video 🙏🙏

[@abhishekdivedi1940]

Good guidance

[@GyanOnTube]

Thank you Abhishek Divedi for your valuable comment..keep sharing keep learning

[@Pixindesign]

Excellent bhai

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@SUMANKUMAR-er6ih]

Very impressed

[@GyanOnTube]

Thank you so much suman..do not forget to share this video

[@giridhariprasad4088]

Excellent. Thank you.

[@GyanOnTube]

Thank you so much

[@omkarchimbalkar5912]

Very nice teaching sir

[@GyanOnTube]

Thank you so much

[@computekplus8237]

nice concept sir

[@GyanOnTube]

Sukriya..🙏🙏..do not forget to share this video

[@omprakashthakur4515]

Sir full tips and tricks videos bnaya outlook365 Microsoft pe

[@GyanOnTube]

Iske upper mene already videos bana rakhi hai..aap mere KZbin channel mein jaake check kar sakte hai

[@omprakashthakur4515]

@@GyanOnTube okay

[@Anil-se9wp]

Excellent video sir... Libre office calc videos please

[@GyanOnTube]

Thank you so much..

[@ImranKhan-hq8mk]

Very good

[@GyanOnTube]

Thank you so much.. don't forget share

[@surajverma1165]

NICE VIDEO SIR JI

[@GyanOnTube]

Thanks you suraj ji..thank you for all your support and help...

[@krmotionexcel]

Great things done

[@GyanOnTube]

Thank you so much

[@RohitKumar-uy7cx]

Bhai kya sirf * hi as a wildcard use hota hai, kya iske alava aur bhi ho to vo saare k bare me bhi ful information in depth

[@GyanOnTube]

Sure Rohit ji unke liye video bahut jald lata hu...

[@dhananjaybranwal7840]

SO NICE

[@GyanOnTube]

Thank you Dhananjay for your valuable comment.. please share this video as well

[@kirandeepchoudhry9232]

Very nicely explained

[@rahulvishwakarma1024]

thank you very much sir

[@GyanOnTube]

Thank you so much Rahul for your valuable comment...do not forget to share this video.

[@rabin3333]

Thnq Sir jii happy Sunday

[@GyanOnTube]

You to robin ji keep sharing and keep supporting..

[@saymaanjum898]

Thanku sir

[@GyanOnTube]

My pleasure sayma..do not forget to share this video

[@rajneesh9483]

Sir paste special ki short key kya hoti hai

[@GyanOnTube]

Rajneesh ji aap CTRL+ALT + V press kar sakte hai

[@Fayaz-Rehman]

Super hit - No need to learn python - Good job -keep it up.

[@GyanOnTube]

Thank you so much Fayaz..do not forget to share this video

[@Iqbaleducation4396]

Pls make also video on pivot table

[@GyanOnTube]

I have prepared entire series of pivot table. kzbin.info/aero/PLWkZ9cU20HYY5u0w2ukS979CLSe8FG1qQ

[@rajeshkumarchoubey2896]

Interesting Tricks , Thanks Sir

[@GyanOnTube]

Thanks Rajesh choubey ji for your valuable comment.. please share the videos with your friends and family and i have uploaded many more videos hope you like those as well.

[@poojaverma161]

Can you tell me sir we have a 4 to 5 sheets and we implement the formula v lookup formula all sheets can u tell me how is it

[@GyanOnTube]

very nice question pooja, i have created one video you can take help from that video.

[@raj5455]

Please make video on usage of if formula with multiple condition & merging wildcard with that.

[@GyanOnTube]

Nice question Souvik ji..i have already prepared a video on it

[@raj5455]

@@GyanOnTube can you please share link of that.

[@GyanOnTube]

@@raj5455 bahut saari videos hai..200+ aap mere playlist mein search kar lo please

[@raj5455]

@@GyanOnTube ok thanks. By the way your videos are very very useful. 👍👍👍

[@GyanOnTube]

@@raj5455 thank you so much dont forget to share this video..

[@vinay103]

Very nice video

[@GyanOnTube]

Thank you so much.. do not forget to share this video

[@RajuKumar-uc5nb]

Good luck

[@GyanOnTube]

Bahut bahut Sukriya Raju Kumar ji...keep sharing and keep learning

[@RajuKumar-uc5nb]

Thanks sir

[@ajaydelhi5]

👍

[@GyanOnTube]

Thank you so much

[@msexcelgooglesheet374]

MAST VIDEO

[@GyanOnTube]

Thank you so much Mr Excel 😊

[@msexcelgooglesheet374]

@@GyanOnTube Welcome sir ji. I need to learn more in excel ..............

[@GyanOnTube]

Sure we will definitely help you with the same

[@ajaydelhi5]

Well done bhai, agar ek cell me multiple entries ho alt+enter ke baad to us data ko individual cell me kese laye, delimited se bhi nhi hua, mera data kafi bada tha, I hope ap smjh gaye hoge, for excel ek cell me name, father name, address, contact no. Etc the aur second entries bhi isi cell me thi. Pls help

[@GyanOnTube]

So you can use texjoin function and segregate with ","

[@User86889]

Sir agar time jo hai wo agar alag day ka nikalna hai jese ki 1 dec 9 am mene kam kia or 3 dec 9 pm tk kia or isme sir 9 to 5 working hours ki count krne hai to kese kre sir.

[@nareshbhagmal]

Superb SOHAN ✌️

[@GyanOnTube]

Sukriya Naresh Mawana ji

[@pkinfo79]

Nice

[@GyanOnTube]

PK info thank you so much.. please share the videos and keep supporting.

[@dipenrai81]

If I type 1+2+3+4 in cell A1, how can I get the sum 10 in cell B2. Which formula should be applied in cell B2. please advice me.

[@GyanOnTube]

Very nice question Dipenn Rai ji..you can use sumNums coading and u will get the answer.

[@GyanOnTube]

Alternative you can try (="="&A1)..then value paste the number then press f2 and enter..you will get your answer

[@dipenrai81]

Sir, can you make a video for its solution please?

[@GyanOnTube]

@@dipenrai81 sure Dipenn Rai ji will make a video on this soon..

[@SanviPatil2019]

Kya baat hai sir

[@GyanOnTube]

Vikas patil ji bahut bahut sukriya and please share this video as well

[@TheJigneshji]

There are multiple rules inside a seat. So how does this formula work by the same name?

[@GyanOnTube]

Can you please elaborate, as i am unable to understand your question

[@vinay103]

Super!!

[@GyanOnTube]

Bahut sukriya vijay Kumar ji please like and share the video with your friends and family..

[@nikhilparimadam]

How to sort in excel 2010, a column containing number with suffix alphabet ,for example 1A 2B 1C 1B 4A 7G etc in a column

[@GyanOnTube]

Hi Nikil in tha case we need to check the prepare a formula according

[@nikhilparimadam]

@@GyanOnTube sir can you tell me the formula...i want in order 1a 1b 1c 2b 4a 7g and so on both numerical and alphabet should be in order.. thanks

[@pramodsigh]

Sir I need help....May I send you excel file for my solution

[@GyanOnTube]

Sure pramod ji will try to resolve it

[@pankajrathore7797]

Agar ek name 2 baar repeat ho to tab kaise kaam karega fir value galat ho sakti h

[@GyanOnTube]

nice question pankaj, iske liye humko wild card ke sath dursa formula use karna hoga...uski bhi ek video mene bana rakhi hai

[@pankajrathore7797]

@@GyanOnTube to us video ka link bhi share kar dijiy

[@GyanOnTube]

@@pankajrathore7797 :- kzbin.info/www/bejne/rIfCYmCQnN2snqc

[@rajeevgosavi4514]

VERY GOOD VIDEO. NICELY EXPLAINED. SIR, COULD YOU MAKE A VIDEO ON XLOOKUP+XMATCH FORMULA TO BE USED IN PLACE OF VLOOKUP+MATCH FORMULA

[@GyanOnTube]

Thank you for your valuable comment Rajeev..i have already made a video on XLOOKUP and XMATCH...and for XLOOKUP we do not need Xmatch Formula

[@rajeevgosavi4514]

@@GyanOnTube Appreciate your prompt response. May I kindly request you to please demonstrate how to use Xlookup instead of vlookup +Match function. Thanks & Regards

[@GyanOnTube]

Thank you.. please find attached XLOOKUP full video. kzbin.info/www/bejne/npyudYBjr7yNgaM

[@totalfunsharma8090]

Sir I have question what can we do when we have same of two or more same names in our sheet because vlookup didn't show two data in one time if you have any solution so please share it sir ♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️♥️

[@GyanOnTube]

Very nice 👌 question sharma ji..if you want to populate all data for unique name..so you can watch this video you will get 100% answer. kzbin.info/www/bejne/Z3PGlntrqLyNe9E

[@srinivasrao3685]

Sir same name double hoga to amount add kaise hoga pls. Batayange.

[@GyanOnTube]

Iske liye mene dusri video prepare kar rahi hai Srinivas..

[@litonmazumder1184]

How to sum >0 and

[@GyanOnTube]

Apply if with and conditions

[@baijnathprasad2502]

Sir 3r word me second word ko find kaise kare

[@GyanOnTube]

Uske liye pehele aapko left formula lagana hoga with find then.. second word mein wild card lagaoo..you will get your answer

[@deepakkeshari1168]

Please help me sir for wildcards not work properly

[@GyanOnTube]

Deepak ji ... theek se apply karo jese mene video mein samjaya hai.. definitely work karega

[@deepakkeshari1168]

so please help me sir for wildcard

[@nikhilparimadam]

how to sort in excel 2010 number with suffix alphabet

[@GyanOnTube]

We can prepare a filter accordingly

[@govinddwibedi4949]

Word 365 ke sare features ko details me btayen video dwara.

[@GyanOnTube]

Sure Govind Dwivedi ji..will make a video soon on it

[@ajaysrivastava8953]

Sir apne to Sohan likha tha to ye baki kaise show kr raha h

[@GyanOnTube]

Aap dhayan se dekho khud samaj aajega aapko...mene sohan ko freez nhi kiya hai jab mene formula drag kiya to usne next row pick kar li..

[@ajaysrivastava8953]

Many many thanks sir

[@rohitgrover3785]

Hello sir Wild card apply to ho rha hain per result proper nahi mil rha. Formula trag karne per kahe per results mil rha hain to kahe per #n|a error ata hain.

[@GyanOnTube]

Rohit ji agar aapne formula sahi lagaya hai to error nhi aana chahiye

[@golmaal935]

Suppose maine search me daala "deveshpandey" aur name list me "devesh Pandey" means with space to wild card use karke answer nahi aata...kaise answer milega?

[@GyanOnTube]

Sirf devesh dal do..aapko saare answers mil jaenge

[@golmaal935]

@@GyanOnTube Yes answer aa raha hai...Thanks for your very fast reply 👍

[@GyanOnTube]

Thank you so much 😊

[@krishnatate4765]

SIR.. mujhe har month main me naya data bharna padta hai, to mujhe pahila data delet karna padta hai, to mujhe 1 sheet pe har month data save karna hai, jaise mai purana month slect karu to usi month ka data ana chai h,our agr main next month slect karu to blanck dikhana chahiye sir.har month ka data save rahna chai hai,without macro... plz help me.

[@GyanOnTube]

Krishna Tate ji why not with macro..you can build a macro it would be simple macro..

[@krishnatate4765]

@@GyanOnTube I heartily thx sir g for reply..😊 sir mujhe macro mushkil lagta hai, without macro ho sakta h kya???

[@GyanOnTube]

@@krishnatate4765 i got ur query..let me try if i can prepare something for u without macro...aur macro bilkul muskil nhi hai..

[@krishnatate4765]

@@GyanOnTube ok sir thx.... Mujhe macro mushkil lagta h sir,wo record karna,file save karna,thoda alg mushkil lagta h.. Sir main pathology lab technician.. Meri duty corona sample lene ki h.. Sir accounting reporting ye fild nhi h meri , bt maine aisehi excel 2,4, videos dekhe to mujhe bahut achha laga excel .... Or ab toh apke videos dekhe to our maja arha h,,our ap reply karte hoto our bhi majja arha h, our m apko mere man har query puch sakata hun,q ki ap reply karte ho.. Thx sir😊😊 Hamare liye ap Corona se surkshit rahiye sir..gn

[@rajivroy4708]

Sir har roj mujhe new sheet. Bhej do mis ka

[@GyanOnTube]

Ok

[@Sudhanshu_Rajput108]

Bhai aap kaha se ho??

[@GyanOnTube]

Delhi se..

[@Sudhanshu_Rajput108]

@@GyanOnTube Home Town yaa Working Town?

[@GyanOnTube]

Dono

[@kirandeepchoudhry9232]

Sir please make video on rest of wild characters like ? with *

[@GyanOnTube]

Point noted Kirandeep Choudhry ji..i will definitely make videos on rest of them where i we can use while card..

[@muhammadsaqlain5162]

Lekin sir ager same name ho to phir kaise use krenge wile card?

[@GyanOnTube]

Tab nhi aaga...uske liye aap if and texjoin condition laga sakte ho

[@muhammadsaqlain5162]

@@GyanOnTube Thanks

[@ghumansaab2314]

Brother agar 2 first name same ho to kaise kare gy

[@GyanOnTube]

Iske liye aapko textjoin and if condition fir lagana hoga

[@deepakkeshari1168]

but my problem not solution for Pan No.

[@yogesh63192]

we can use text to column simple

[@GyanOnTube]

Robert rude ji..aap kitni bari text to column karoge...test to column acha option hai however but aapke pass multiple criteria ho aur second ya 3rd name populate karna ho to wo bahut difficult ho jaata hai

[@deepakkeshari1168]

Sir, one video share of Party name with pan card number and formula use Vlookup but party name is spelling mistake so not properly work wildcard

[@rajivroy4708]

Sir mis ka sheet kara do plzz sie

[@GyanOnTube]

Mis ka sheet ka matalab..??

[@adityasharma0101]

No professional should use word such as "Black Magic" for Excel functions. Judging a book by its cover is not good but in this case it is justifiable.

[@bharduwajom]

Agar name duplicate ho to vlookup kam nahi karega

[@GyanOnTube]

Nhi ye tab nhi work karega..isliye liye mene ek aur video banaii hai..aap wo check kar lijiye..jo textjoin and if condition le sath banaya hai mene

[@yadhukrishnan8299]

Hlo sir, mera ek query dha, Agar yahi cells me,"-", double bar lag gaya,jaise ki "AB1-87465-146872" Is situation me kaise hoga

[@GyanOnTube]

To aap ek star aage laga do aur ek piche

[@yadhukrishnan8299]

@@GyanOnTube full delete hogaya sir

[@yadhukrishnan8299]

Sir is data se mujhe 87465-146872 extract karna hai

[@deepakkeshari1168]

Sir, hamare pass 1000 se jayada data he us date me se humko pan no fill karna he but party ka name spelling is mistake so not pan fill properly

[@GyanOnTube]

Deepak ji party ka name ke agar spelling galat ho to aap minimal charector se search kariye

[@TINKUKUMAR-hl7sz]

4 se 5 name ko kaise add karenge ek sath me...

[@GyanOnTube]

Tinku kumar ji..aap un names ko alag alag rows mein put kar sakte ho..agar aap ek sath put karna cha rahe ho uske liye aapka row data bhi usi format mein hona chaiye..

[@deepakkeshari1168]

Sir Mera WildCards Nahi chala

[@meenubajaj6765]

Sir I have an excel query for which I want to send u worksheet can u please provide ur mail I'd. Thanks in advance

[@GyanOnTube]

Hi Meenu, you can join my telegram group for real time solution.. telegram id below @Excelinhindi

[@meenubajaj6765]

Thank you so much

[@jagrativerma2117]

is video ka baad yeh video jarur dekhe kzbin.info/www/bejne/qmjEXpV8rZiLb7c