combination formula || How to make big formula in excel in hindi || combined variance formula

#combinationformula , ye video aapko #excel mein formula prepare karna bataegi aur aap excel ka new tricks and tips bhi seekh sakte hai aur saare #advancedexcel ke formula bhi seekh sakte hai. is video mein aap #ifCondition ko indepth mein seekh sakte hai.
********************
Download Link :- drive.google.com/file/d/1Ur2Y...
*********************
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)*******

[@maheshasodia4960]

वाकई में आपसे अद्भुत सिखने को मिला . फॉर्मूले तो बहुतो ने बताये पर मर्जिंग किसी ने नहीं बताये थे . धन्यवाद . जय हिन्द सर

[@GyanOnTube]

Aapke comment ke liye bahut bahut sukriya..esse hi channel ke sath bane rahiye aur bhi videos aap logo ke liye aati rahegi....keep learning keep supporting

[@prashanttyagi1156]

Amazing way sir for merge the formula . Thanks

[@GyanOnTube]

@@prashanttyagi1156 thank you so much Prashant 🙏.. video ko share zaroor karna

[@pramodbhavsar4488]

Sir aapne bhahuthi hi achhi tarahse badesebadaa formula kaise banatehai with practical examples ke saath samjaya very useful to us thank you sir

[@GyanOnTube]

Thank you so much Pramod ji for your valuable comment... please share this video

[@buntyrana8775]

you are great boss big salute

[@GyanOnTube]

Thank you so much 🥰

[@pramodbhavsar4488]

Sir aapne vlookup or if formula ka Jadu bataya or multipal formulaki trick ke liye thanks verygood idea

[@GyanOnTube]

Parmod bhavsar ji..agar aapne seekh liya to last mein ek challenge question hai..usko zaroor karna aur mujhe comments mein wo Formula past karna..isse aapki learning increase hogi..

[@SanviPatil2019]

Wow kya bat hainsir..bahot badhiya formula sikha ya

[@GyanOnTube]

Vikas bhalekar patil ji sukriya..ye video aapne dosto ke sath bhi bilkul share karna..

[@onlyexcel493]

Sir I will try my best 👍

[@bharatsinghrathor3082]

Nice video bro....agar hum iferror ke saath v-lookup lagayenge tab bhi ye ho jayega hum excel use karte hain time saving ke liye formula combine karne me time lagta hai.... excel me merge karna seekha maine aapka video dekh ke bohot achcha Laga....

[@GyanOnTube]

Thank you so much Bharat singh rathor ji..mein esii hi videos lata reheta hu aap logo ke liye..aap is video ko aapne friends ke sath share zaroor karna...aur aap logo ka support aur pyar chaiye..🙏

[@lavleshsingh3860]

Yes I'm crack this challenge formula Thank you sir

[@GyanOnTube]

Thanks great..👍👍

[@ashwani5616]

index, match formula can be used in place of vlookup function..

[@GyanOnTube]

Hi Ashwani, Yes ofcourse ..we can use index and match Formula instead of vlookup..

[@anantahembram4989]

Really really nice video sir ji ....

[@GyanOnTube]

Thank you Ananta Hembram ji..aap logo ke pyar aur support ke karan hi mein esii videos bana pata hu..is video ko aapne friends ke sath share zaroor karna..

[@anantahembram4989]

Ok sir

[@jayprakashprasad754]

Very nice formula sir. Senders J.P.

[@GyanOnTube]

Jayprakash Prasad ji aap ke comment ke liye bahut bahut sukriya..aap logo ka support chaiyee..is video ko aapne friends ke sath share zaroor karna..

[@anishanagpal7004]

Thank you

[@GyanOnTube]

Thank you so much

[@atulshukal4072]

Good Sir Thenks 👌👌👌

[@GyanOnTube]

Bahut bahut sukriya Atul ji

[@madhunaik3152]

Thank you guruji

[@GyanOnTube]

Thank you madhu..do not forget to share this video

[@tanveerhussain3881]

best

[@GyanOnTube]

Thank you so much

[@nareshbhagmal]

Supeb Dude

[@GyanOnTube]

Thank you Naresh Mawana ji..your comment are very helpful.

[@AjayKumar-nr3jo]

👍👍

[@GyanOnTube]

Thank you Ajay Kumar ji..keep sharing keep learning

[@SKumar-nm7rz]

Power Query ka ek series banayee pls

[@atulkhiste9345]

Thanks , Great Formula Sir, I have a Query if my cell value repeated more than twice/repeated in data in both conditions, then what will be my formula?

[@GyanOnTube]

For this i have created another video with if and textjoin condition

[@onlyexcel493]

Happy Christmas day my dearest sohan sir

[@GyanOnTube]

Marry Christmas to u Nileshgiri ji..is video ke last me ek challenge question hai wo try zaroor karna.

[@onlyexcel493]

OK sir I will try my best

[@GyanOnTube]

@@onlyexcel493 sure will wait for your answer

[@onlyexcel493]

Wish you a very very happy merry Christmas day friends

[@saurabh17sharma68]

index match se ho sakta hai sir

[@GyanOnTube]

Bilkul ho sakta hai..aap try zaroor karna..

[@svs20081963]

sir kindly refer combined formula ( challenge heading city and name mistyped), =IF(IF(IF(VLOOKUP(I17,D6:G22,2,0)="Patna",VLOOKUP(VLOOKUP(I17,D6:G22,2,0),E6:G22,2,0),"No Data")=44000,VLOOKUP(IF(VLOOKUP(I17,D6:G22,2,0)="Patna",VLOOKUP(VLOOKUP(I17,D6:G22,2,0),E6:G22,2,0),"No Data"),F6:G22,2,0),"No Data")=0.4,"Yellow","Red")

[@svs20081963]

sir this we can also easily do by Advance Filter too

[@GyanOnTube]

Yes seetharam Shetty ji .. however this was just an example how we merge Formulas.

[@amitkishor811]

Numerical number दे और हिंदी नंबर में बदल जाए इस पर एक वीडियो बना दीजिये। plz help me.

[@gunindradas8042]

Sir On Sunday I try to paste the formula in the comment box. Now I am at office.

[@GyanOnTube]

Sure gunindra das ji..aap sunday ko paste kar dena and please share the video as well

[@prashanttyagi1156]

SIR YOUR CHALLENGE PRACTCE FILE ANSWAER IF(LOOKUP(IF(VLOOKUP(G5,CHOOSE({1,2},C4:C20,B4:B20),2,0)="PATNA",VLOOKUP(VLOOKUP(G5,CHOOSE({1,2},C4:C20,B4:B20),2,0),B4:E20,4,0),40%),E4:E20,D4:D20)=44000,"YELLOW","") I HAVE DONE THIS COBINATION OF FORMULA IS IT RIGHT? MY ANSWER IS ACCURATE THIS TYPE.

[@learnwithdkg]

I can use index with match formula

[@GyanOnTube]

Yes please give a try..

[@narindersharma2087]

Hello, would appreciate to manage this formula arrangement with common name but the different related values or different names with common related values

[@GyanOnTube]

For this kind of checks i have already prepared a videos for the same

[@narindersharma2087]

@@GyanOnTube please share the link

[@prashanttyagi1156]

Sir hum isko vlookup+ choose se bhe ker sakte hain aur vlookup+ array se bhi kervsakte hain . Am I right sir

[@GyanOnTube]

Billul sahi kaha Prashant aapne..

[@prashanttyagi1156]

Thanks sir aap se hi seekha hai bus halka sa apna deemaag laga ke kiya aur ho gaya

[@GyanOnTube]

@@prashanttyagi1156 great job ...ese hi seekhte raho...👍👍

[@kanailalsaha4865]

Sir I need one formula in which quantity of 15 item is fix, total amount is fix and rates are variable

[@GyanOnTube]

Yes you can apply function with row and column formula

[@gopalsinghchouhan5677]

Index+match

[@GyanOnTube]

Yes ofcourse 👍

[@harikeshsingh6937]

Laajawaab

[@GyanOnTube]

Bahut bahut sukriya Harikesh singh ji...keep learning and and keep supporting

[@rajivroy4708]

Sir mujhe mis ka questions karna hai

[@GyanOnTube]

Iski puri series hai aap check out kar sakte hai

[@mohdabdullah452]

Sir challenge qstn smjh nhi aaya is pr aapne video nhi banaya

[@GyanOnTube]

Sure mein zaroor video bana dunga ispar

[@amitkishor811]

दो शीट है एक शीट ब्लेंक है और दूसरी शीट पर डाटा है जो डाटा है वो पेन्डिंग है उस पर disposed करें तो ब्लेंक शीट पर कट होकर चली जाय। इस पर एक वीडियो बना दीजिये। thank you. mail id - [e-mail]

[@GyanOnTube]

Amit kishor ji nice suggestion..i will prepare a video on this very soon..

[@amitkishor811]

Thank you sir

[@ramkripalkumar2943]

When double clicked into cell where formula is present, it don't work means don't work the formula

[@GyanOnTube]

Can you please elaborate.. unable to understand your question

[@maithilnitesh]

Sir pl find the revised formula below =IF(IF(VLOOKUP(INDEX($C$4:$C$20,MATCH("Rohit",$D$4:$D$20,0),)&""&"Rohit",$B$4:$F$20,5,0)=0.4,INDEX($E$4:$E$20,MATCH(0.4,$F$4:$F$20,0),),"No Data")=44000,"Yellow","")

[@GyanOnTube]

Very impressive 👍 Nitesh Mishra ji..the formula you applied is really gud..keep up the good work.

[@maithilnitesh]

@@GyanOnTube Thank you sir This could be done by your guide and support. Once again Thanks 🙏

[@GyanOnTube]

@@maithilnitesh thank you for your valuable comment.. keeping supporting and keep sharing..

[@gunindradas8042]

Too long formula sir and the image upload option is not available in comment box

[@GyanOnTube]

Gunindra das ji..hope you understand why i am not sharing my email over youtube comments box..you can join my telegram group and share details there.. @Excelinhindi

[@sagarmestry8090]

Sir muje ek formula banana hai Kay aap help Karege

[@GyanOnTube]

Sure sagar mestry ji you can join my telegram group and give me information there, will help you for sure @Excelinhindi

[@sagarmestry8090]

Plz send telegram chalel link

[@SKumar-nm7rz]

Plzz भाई साहब solution बताइए नहीं हो रहा है

[@GyanOnTube]

Sure s kumar ji..aap try karo zaroor ho jaaega..bus index match lagana hai

[@BalvirSingh-qs9kz]

No knowledge, sir very- 2 thanks. Sir ek data he jo aapse jankari karna he aapko kaise bheje?

[@GyanOnTube]

Aap mera telegram group join kar sakte hai aur waha information bhej sakte hai.. Telegram :- Excel in Hindi - Gyan On Tube 👇👇Telegram link👇👇 t.me/Excelinhindi

[@sathyanarayana4914]

pls send me this file links

[@GyanOnTube]

In description below

[@maheshdabhade1]

Dream11 combination formula sheet ?

[@GyanOnTube]

Aap wo banana chate hai ya aap humse banwane ke liye bol rahe hai

[@maheshdabhade1]

@@GyanOnTube ap bana sakte hai kya?

[@GyanOnTube]

Ha bilkul bana sakta hu..aap thora logics bataoo..mein kosis karunga ke uske upper video zaroor lauu

[@maheshdabhade1]

@@GyanOnTube kzbin.info/www/bejne/fYGXqoWum9aFipY

[@austindean9274]

Like too much

[@GyanOnTube]

Thank you so much 😊

[@RajeshPatel1604]

Sir ads kyu nhi aa rhe h

[@GyanOnTube]

Kaun se ads

[@RajeshPatel1604]

@@GyanOnTube jo video pr aati h

[@GyanOnTube]

@@RajeshPatel1604 no idea

[@RajeshPatel1604]

@@GyanOnTube watch time complete nhi huya kya

[@luckybicantt3523]

gm sir XLOOKUP

[@GyanOnTube]

Lucky bi ji..try to solve the challenge question and don't forget to share the video with your friends and family