Sir aap excel ke king ho....aapke wajah se hi lakho bacho ko excel intersted lagne laga hai aur mujhe bhi....mai dono answer de diya hu sir video dekhne se pehle 🙏❤️😀
Nice boss..Bhai ye jo video k end me motivational line dallte ho na ye apki video ko or effective bana deti hai.. I think ye script app k khud k he words hote hai.. Jatadhari ji ko ki c video meain dubara laye... Thank you for your love & support thank you dill se..
You have already done it or doing it for this world..I haven't seen any RUclips channel which has content like yours specially of MS-Excel basic to advance level thanks to you dill se..
Suppose that we have the price and the brand name, and we need to find the year, I have a big data sheet where there are the revenue and the Brand Names but I have to insert the year in the next column for each price. how will you do that? please.
Sir mah aap seh bohot jaldh EXCEL, VBA & Power bi ka ofline video wali course buy karne wala hu. But sir mujhe kuch sawal h...... 1)Excel mah toh every year new formulas aate h.....kya aap new changes and formulas ko apne course mah add karenga every time. 2) aapka doubt session 1-2 time/s hoti h monthly......kya mah every month participate kr sakta hu.....?
Hi Sir..I have learnt so many excel function from your video's ...but sir I have faced a situation in Excel which I failed to crack.. Situation is.. There in Column -A . obtain project code and Column -B. Shows name who work in project..now I want to move all name in column Link ..in Col-A projectcode is "1111" and people work -"AA, BB, CC, DD" THIS IS SHOW IN ROW LEVEL..THEN HOW TO MOVE IT IN COLUMN LEVEL BESIDE THE PROJECT CODE....( IF I DO MANUALLY I USED TRANSPOSE BUT .DATA IS BIG AND IF I FOLLOW THIS PROCESS IT WILL TAKE MANY TIME... PLEASE HELP....IF POSSIBLE.. THANK YOU IN ANTICIPATION ..
Sir apny phly wala MATCH function lagaya h wo galt h. Q k INDEX me phly array hota h then row number then column. SAMSUNG jo h wo ro me h jbky apny column me put kr diya h.
उदाहरण मेरा डाटा है उसका टोटल वेल्यू 40000 है SrNo Supplier Name Sale 1 Malahar 1000 2 Gardian 3000 3 Safar। 12000 4 chahar 14000 5 sify techno 10000 Isme se muze sirf 18000 ka hi data chahiye to kya mil sakta hai ??
Sir aap excel ke king ho....aapke wajah se hi lakho bacho ko excel intersted lagne laga hai aur mujhe bhi....mai dono answer de diya hu sir video dekhne se pehle 🙏❤️😀
Great .. thanks dear
U r master of all youtube teachers of excel.
Thanks Vishal ji
खुद ही चलना है, is heart touching word, but it's true.
Now I got Excel 20% out of 100.
Thanks..Keep exploring
Very greatest video sir
Such mein sir app ke jaisa koi nahi padhate hai thank you so much sir
Thanks Dear...Keep learning
Good one. Loved the way you put the things in a very SIMPLE way
Thanks
Next level of Teaching, thank you so much sir.
Thanks Shiv
Great logic Sir.
Thanks
Amazing. So subtle
I learnt a lot from your videos I request you to make video on lambda function because after watching many videos it's still not clear to me
Sure dear .Will make videos on lambda
Sir Gee Love your content❣️Daily viewer.
Thanks dear
Very helpful video ❤ sir
You are great Sir
First comment & viewer and like.. ❤️
Godfather of Excel
❤️
Nice boss..Bhai ye jo video k end me motivational line dallte ho na ye apki video ko or effective bana deti hai.. I think ye script app k khud k he words hote hai.. Jatadhari ji ko ki c video meain dubara laye...
Thank you for your love & support thank you dill se..
Thanks dear..Koshish karta hu aap sabhi ke life me value add kar sakun
You have already done it or doing it for this world..I haven't seen any RUclips channel which has content like yours specially of MS-Excel basic to advance level thanks to you dill se..
Sir very helpful & concept clear video 🥳😍👍✌
Thanks
Very very useful 👏
Good to see your subscribers growing..
Congratulations.. 🌻
Thanks Sandeep for wishes
happy learning dear
Sir 2 no. Question mein hum jaha column no. Mangega wahi match kara lege AMPERSAND & lagakar 2 values ko year&quantity ..... Sayad ye work kare ... 🙏
❤️👍
Thanks for this fruitful session.
Sir please start sql video course soon!
Thanks Dear...Yes after completion of power bi and VBA series
THANK SIR THIS QUESRTION ASKED MY IN INTEVRIEW WHERE THE HEADERS R IN DIFFERENT CELL
Thank you sir 😊
Thanks dear
Mast sir ji 💜
Suppose that we have the price and the brand name, and we need to find the year, I have a big data sheet where there are the revenue and the Brand Names but I have to insert the year in the next column for each price. how will you do that? please.
Sir merchandise🔥
Super sir
Sir mah aap seh bohot jaldh EXCEL, VBA & Power bi ka ofline video wali course buy karne wala hu. But sir mujhe kuch sawal h......
1)Excel mah toh every year new formulas aate h.....kya aap new changes and formulas ko apne course mah add karenga every time.
2) aapka doubt session 1-2 time/s hoti h monthly......kya mah every month participate kr sakta hu.....?
Humesha course update hote rahte hain video cours ke
Doeubt session ki koi validity nahi aap attend kar sakte hain harek month me once or twice
Ye kam to vookup aur concaneted formula se bhi kar sakte hai
Sir aap ish channel pah VBA ki series laoge kya ??
Because VBA playlist mah VBA k videos randomly uploaded h.
Random videos nhi hai in sequence playlist Bhai VBA aur power bi ke dear
Jakkkkas sir 🙏
Love from pakistan😘😘👍
❤❤❤
Nice sir
🔥🔥🔥🔥🔥🔥
🙏
Great Teacher Love From Pakistan
Thanks
❤
Sir it's a humble request to you sir please start SQL structure query language series
Noted
@@Innozant thanks sir for geniune reply
Nice but i am already known index match multiple header's .problem
❤️👍
if my first lookup is not exact match how to solve it
Agar year ka coulmus merge kar diya jaaye to formula kaise
Sir, you have exchanged the row_num formula by column_num formula and column_num formula with row_num formula so getting incorrect results.
❤️👍
I do think the same mistake of exchanged array selection of rows and columns viseversa.
Solution: If I am right, in case of Index/match header row also has to be included. So, kindly chnage the range: A4:h11 -------- h4:h11.
❤️👍
I'm The First Liker
Sir 1st question mistake : row no. Ke place per column ko match hua hai and column no. Ke place per row match hua hai ...isiliye wrong aaraha hai 🙂
❤️👍
Hi Sir..I have learnt so many excel function from your video's ...but sir I have faced a situation in Excel which I failed to crack.. Situation is..
There in Column -A . obtain project code and Column -B. Shows name who work in project..now I want to move all name in column
Link ..in Col-A projectcode is "1111" and people work -"AA, BB, CC, DD" THIS IS SHOW IN ROW LEVEL..THEN HOW TO MOVE IT IN COLUMN LEVEL BESIDE THE PROJECT CODE....( IF I DO MANUALLY I USED TRANSPOSE BUT .DATA IS BIG AND IF I FOLLOW THIS PROCESS IT WILL TAKE MANY TIME...
PLEASE HELP....IF POSSIBLE..
THANK YOU IN ANTICIPATION ..
Sir I am extract data from other sheet but VALUE aa Rahi h
Sir apny phly wala MATCH function lagaya h wo galt h.
Q k INDEX me phly array hota h then row number then column.
SAMSUNG jo h wo ro me h jbky apny column me put kr diya h.
Very true 👍
उदाहरण
मेरा डाटा है उसका टोटल वेल्यू 40000 है
SrNo Supplier Name Sale
1 Malahar 1000
2 Gardian 3000
3 Safar। 12000
4 chahar 14000
5 sify techno 10000
Isme se muze sirf 18000 ka hi data chahiye to kya mil sakta hai ??
मेरा एक बड़ा डाटा है उसमें से मुझे सिर्फ इतना ही डाटा चाहिए जिसका वेल्यू में चाहूं उतना ही डाटा मुझे मिले
गलत है भैया मै same try कर चूका हु नहीं होगा आप कोनसा version है ये plz reply 🙏
I need help
Share your query @innozantofficial telegram id
गलत है मे same try कर चुका हूँ office 365 है क्या
Office 365...it is perfectly fine
@@Innozantतभी गलत आया है मेरे पास 2016
Boss. Nice video but you forgot to mention a very important point in second option.
IT WILL NOT WORK IF IF YOU DONT USE CNTRL SHIFT ENTER!!!🥲😘👍
Office 365- Dynamic array.,no need to press Ctrl shift enter but yes in earlier version it's mandatory 😊❤️😊