Wonderful knowledge sharing... I am working in IT.. and I used to search for excel tutorials some time.. but I never found such a nice explained video in very minimal duration. Now I started seeing this guy's videos even if I don't need that tutorials for any purpose. Because I know the new unknown ideas may help me later and worth watching as videos are very short.. and really very short without missing any details 🙂
Bro, I practiced this tips in my excel work book. But this formula is workable for only for the first name cell in the the look up value name list. How we get all cells in the name list ?
@@rows_columns Please can you give the link of the video where multiple list of value filter tutorial is there. As in this video you mentioned while choosing the location , state & number. from one cell. I searched for the video. Could not find
Hi sir ..✋ I confused, but now it's okay .... I joined with a Deepak who is doing excel classes and now am able to do index,match 🕺🕺 Thankx... I trained vlookup on ua class it was short and gud class ☺️
Thanks for watching! 😊 Excel Free Practical Worksheets ആവശ്യമുള്ളവർ താഴെയുള്ള ലിങ്കിൽ നിന്നും Download ചെയ്യാൻ സാധിക്കുന്നതാണ്😊 www.rowscolumns.com/free-excel-templates
sir diffrent format ulla two excel sheet reconciliation cheydu errors find oit cheyyanulla solution undo.. pinne bank reconciliation nammal chila amount rando or adil kooduthalo ulla amount aakum so adu sort out cheydu edukan formula undo?
Apologies for the delayed response; my system is currently undergoing maintenance due to technical issues. You can access the requested file through the link below. Thanks for your understanding and support 😊 drive.google.com/drive/folders/1WArNDI5AYVkHKB-Vxdl3V3u6xtjFT7xJ
while dragging or copying the formula to the remaining cells, the cell positions are getting changed and the value returns as N/A even post locking the cells. Could you suggest a solution to resolve this
Oru doubt ind onnu clear cheyth tharanam.. oru cellil India pinnoru cellil Name pinnoru cellil number.indiayil kerala and taminadu und appol ith moonum koodi ethra ennam und ennu ariyanam
Bro suppose oru column thil oru specific data adichu, if enik next varunna multiple columns IL oronnilum first adicha datayude nere aa datayumay bandhapeta fixed aayitulla vere data's auto fill aayi varuthan patumo.means example movies and it's details Varunna oru sheet ennu karuthuka, athinu nere next varunna column ngal Director, actor, producer, year of release ennu karuthuka.njan oru movie de Peru mathram first column thil adikumpo aduthulla ella column thilum athinte details autofill aayi varuthan patumo ennanu chothikunnne....pls give me a reply if possible....thank you
i have tried with location, salary and employee number. Location datas are not showing, rest is coming if i change the filter. what would be the reason
Hai sir, I am rahman from KSA. please help, engineyanu sumifs function ubayogichu (two or three criteria) oru data yil ninnu annual total cheyyunnathu, monthly total eomonth ubayogichu enikkariyam but annual total?
Awesome brother. Really useful. In fact we are getting a very good training for those who know the basics. Appreciated attitude
😊
@@rows_columns 13:11 13:11
@@rows_columns Hi Alfan ,P value related oru detailed video cheyyamo?
Wonderful knowledge sharing... I am working in IT.. and I used to search for excel tutorials some time.. but I never found such a nice explained video in very minimal duration. Now I started seeing this guy's videos even if I don't need that tutorials for any purpose. Because I know the new unknown ideas may help me later and worth watching as videos are very short.. and really very short without missing any details 🙂
Thanks for your valuable feedback brother😊
life saver video
ബ്രോയുടെ vedios എല്ലാം നല്ല രീതിയിൽ ഉപകാരപ്പെടുന്നുണ്ട് ... Thanks bro....😍😍🥰🥰
Bro,
I practiced this tips in my excel work book. But this formula is workable for only for the first name cell in the the look up value name list. How we get all cells in the name list ?
super .. ❤️❤️ thanku
Adipoli class... Very useful.... Thank uu sir
How excellent you are rendering, and your voice modulation , action more over the subject knowledge......wonderful
Thanks Brother :)
Very very useful. Thank you so much
Pleasure is mine😊
@@rows_columns Please can you give the link of the video where multiple list of value filter tutorial is there. As in this video you mentioned while choosing the location , state & number. from one cell. I searched for the video. Could not find
@@ambikamukundan7044 Yeah sure, ua-cam.com/video/CSGVA-wfDCs/v-deo.html
@@rows_columns Thank you so much🙏🏼
@@ambikamukundan7044 Most welcome Madam😊
Excellent tutorial. We use it regularly for maintaining Forex rates for Oracle EBS & glad to find the explanation in Malayalam :)
Most welcome brother😊
Inventory Coordinator aayit work cheyyunna aalanu njan
Broyude videos orupadu upakarappedunund 👍💐
Glad to know that bro😍
Your explanation fantastic and easy methord for understand everyone.
🙏☺️
Every video has very well.
Thank you so much
❤️😊
Actually..nuw only I understand about index match function in detail..thanks🎉
Good presentation
Thanks brother
Till @11:28 I was thinking, xlookup is much simpler than this.
Only when users have office 365 version😉
Excellent job mr. Al fan. I have seen couple of your videos its really informative and excellent presentation. Recently i noticed your channel.
Thanks a ton Mr.Rafi😊
Thanks a lot, sharing information
Thank you, I am happy to hear you feel that way!
Very helpful tool, thanks
Glad it was helpful!
Tried this. Working Cool...
Appreciate your positive feedback! Thrilled to hear you liked the video. Keep enjoying and stay tuned for more!😊
Crystal clear presentation... thanks bro...
Thank you!
Vlookup inu alternative ayittu ella idathum use cheyyan patille??
Yes.. Pattum
Very powerful tool and powerful explanation.excellent
Thanks for giving new knowledge
Really you are a master! But if you reduce the speed in explaining the matter it would be beneficial to a person like me. Thanks.
Well noted😊👍
Thank you so much
🥰
Very useful tool. I have never tried this. Thank you
super class... thanks ..bro
Welcome
thank you dear sir...........
go ahead
🤘😊🤘
How to do sorting mixed numbers as text. Eg: want to sort A1,A2,.... In series. It should no A1, A11,A12,...A19, A2. Like. I am using excel 2016
Please check my below vid
ua-cam.com/video/006AqJ9dnNk/v-deo.html
Very informative.. thank you very much 👍🏼
Please put vedios related loans value, emi like PMT, NPV
Nicely taught.
Thanks great video (y)
Njanum vote cheydhadh vlookup aan but ini maaty pidikkum for ever my favorite is index and match
😅✨
Bro thanks a lot for this video ❤❤❤
😊
Awesome👏👏👏… Nice presentation.
Thanks for the visit
Nice 👍, what is the need to lock using F4?
Pls check this video
ua-cam.com/video/t7r1UT-4pCI/v-deo.html
Very well explained. Thku alfan
Hello Sir. Can you give me the link of video Of how to create a Data Entry .. which is useful for hospital staff record ..etc... thanks
Practical sheet you can get it from👉www.rowscolumns.com/free-excel-templates😊
Thank you
Have you ever worked with Tyco?
Conditional formats nte oru video cheyyuo ?
👍
Thank you sir ❤
Very good bro...very useful❤️
Glad to hear that
Valuble videos big clap for you Brother !!!
❤️
Could you please share your exclusive video of'Text to column'. Thanks bro..
Definitely Bro👍😊
Videos on pvot table in detail???
Already uploaded.. Kindly go through it😊
Very helpful ...
Match column H1 should lock, otherwise while dragging the formula to bottom will get N/A values.
അടിപൊളി മച്ചാനെ
Machane intro powli
🙏😬
Worth to watch, Thank you so much ❤
Tnx Man🍃😊
XLookup is my favourite one
I personally found Vlookup+match combination to be more handy than index-match
good explanation
Hi sir ..✋ I confused, but now it's okay .... I joined with a Deepak who is doing excel classes and now am able to do index,match 🕺🕺
Thankx... I trained vlookup on ua class it was short and gud class ☺️
🔥🙌
subject against multiple value sum kandu pidikkan oru tool venam
Okke shariyaakam😉
Great Bro..
😊
Well explained 🙏🙏🙏
Great 👍🏻🌹
😊
Same name il 2 alukalum avr 2 state lum ankel egane identify cheyan kazhiyum
Good question
I Also want this question answer
Apply XLOOKUP
Very good. Keep it up 👍
Thanks for watching! 😊
Excel Free Practical Worksheets ആവശ്യമുള്ളവർ താഴെയുള്ള ലിങ്കിൽ നിന്നും Download ചെയ്യാൻ സാധിക്കുന്നതാണ്😊
www.rowscolumns.com/free-excel-templates
@@rows_columns Do you know 'STATA'?
Whats the difference between Index match vs Dget function ??😊
Hi Alfan , Your Videos are so good. Do you have" what if function'" video??
Yep😊👉ua-cam.com/video/GRxIPuBoD44/v-deo.html
How apply index serch for duplicate containte data. Please reply.
Dear Sir , engane ippo karnadaka kodukkumboll thinte aganist ulla ella aalkkarudeem details varaan enthaa cheyyendee
Hi Mr.Alfan
Awesome presentation..👌
Hello sir just one request, previous videos kananam ennu paranjal aaa link description box il koduthal easy aayirunu. Just request.
Well noted brother😊
Thankyou ❤️
sir diffrent format ulla two excel sheet reconciliation cheydu errors find oit cheyyanulla solution undo..
pinne bank reconciliation nammal chila amount rando or adil kooduthalo ulla amount aakum so adu sort out cheydu edukan formula undo?
How to lis all data matching with given criteria based on index match function
Usefull 100%
For right side we can use xlookup?
Well explained 🥰
How can create dialy attendance signing sheet from monthly roster with dayoff
Awesome, but drop down cheyyumbol N/A anu varunnathu?
Heading drop down chyne videonte link idumo?
U can search in playlist😊 ‘Drop down’
i am getting first raw exact figure , but after dragging below result is coming #N/A
Could you please clarify
Just put $ before H2 cell😊 while dragging down…
Thanks sir
I HAVE A DOUBT SIR, I PRECTICED THIS FUNCTION, BUT I CANT TRAG TO THE NEXT CELL, IF ANY PROBLEB??
Hai, it same sheetil maatramano work aavunnat
Nop.. all sheets👍
good job bro
Bro one doubt , after dragging down that list, under the column Employee no, its not autofilling its showing #NA.
What if column G Having multiple look up values , like jayaram having 2 locations ,
How we can add 2 locations in a name
Sir how we can download the different Excel templates to learn different Excel formulas?
Apologies for the delayed response; my system is currently undergoing maintenance due to technical issues. You can access the requested file through the link below. Thanks for your understanding and support 😊
drive.google.com/drive/folders/1WArNDI5AYVkHKB-Vxdl3V3u6xtjFT7xJ
JAYARAM ന്റെ details കിട്ടുന്നുണ്ട് പക്ഷെ താഴേക്കു drag ചെയുമ്പോൾ Usha മുതൽ #N/A ആണ് കിട്ടുന്നത്.. Please help.
For me also.why ?
Lock H1 by pressing F4 (Absolute reference)😊
@@rows_columns thank you
while dragging or copying the formula to the remaining cells, the cell positions are getting changed and the value returns as N/A even post locking the cells. Could you suggest a solution to resolve this
Press F4 to lock the table array. You can see $ sign if locked. Then copy formula. It'll work✌🏻
Oru doubt ind onnu clear cheyth tharanam.. oru cellil India pinnoru cellil Name pinnoru cellil number.indiayil kerala and taminadu und appol ith moonum koodi ethra ennam und ennu ariyanam
Apply CountIF function
Bro suppose oru column thil oru specific data adichu, if enik next varunna multiple columns IL oronnilum first adicha datayude nere aa datayumay bandhapeta fixed aayitulla vere data's auto fill aayi varuthan patumo.means example movies and it's details Varunna oru sheet ennu karuthuka, athinu nere next varunna column ngal Director, actor, producer, year of release ennu karuthuka.njan oru movie de Peru mathram first column thil adikumpo aduthulla ella column thilum athinte details autofill aayi varuthan patumo ennanu chothikunnne....pls give me a reply if possible....thank you
Hi is there any one on one course available?
very good video, I have one doubt why you didn't use "f4" in H4
in H1
Programming VBA Anugst exam Tally important question para plz
ടൈം ഷീറ്റ് ആൻഡ് ഓവർ ടൈം
വിത്ത് ഫ്രൈഡേ calculation വീഡിയോ
👍Idaam
@@rows_columns ok thanks
വിശദമായ വീഡിയോ
i have tried with location, salary and employee number. Location datas are not showing, rest is coming if i change the filter. what would be the reason
Drag cheyyumbol thazhe ulla cells no result kanikkunnu,why? Please help
Hai sir,
I am rahman from KSA. please help, engineyanu sumifs function ubayogichu (two or three criteria) oru data yil ninnu annual total cheyyunnathu, monthly total eomonth ubayogichu enikkariyam but annual total?
📌To Learn Microsoft Excel in English, Click on the Below Link:
ua-cam.com/video/Cn3-bLDkGMY/v-deo.html
How to do "left across selection" instead of "Center Across selection" ?
I don’t think we have that option…
Super