Practice file is also provided in the usual location, utilize it if needed. Thanks for your comment, request you to introduce our channel with your best friends.
Thank you very much. Please come out with more such videos. My suggestions you can start an online class for those who want to learn excel. If you already have please let us know how to.
Hi bro, I really loved your videos and it will be very useful for me. the way your are explaining and teaching with an example makes me to understand the concept much better. Keep doing this good work
nice concept dude. While running the video u ask one question.. what is meaning of #### this error...ii want share wat i know..Genereally this display two concepts such as, that particular cell does not fit value(i.e, if the value was too large) during that time we expand particular cell we get solutions.second one is if we give wrong format like one cell contains under date format means we insert negative value or any wrong data means during that time we face this issue.. finally it is my predication i donwt know wheather this one right or wrong but i want to say what it means we lock T3 cell at the same time we drag formula to all columns t3 is fixed reference . we delted t3 cell values (emp id) so all coulms value depends in t3 cell so it reflects ### error to all coulms at same time dude am i rit?
If you have any second instances, you have to use the * Advanced Lookup* option, watching the following video can tech you the trick: ua-cam.com/video/dqgJbpcW0PA/v-deo.html
Sir, In the same concept how set the indication alarm (pass/fail) letter instead of number? Example - 123456 - pass 345726 - pass 12b45a - fail c323h6 - fail
Sir, I have tried if function with some formula but indication will not not come, so that pls send both (letter inseated of number & number instead of letters) indication formula to me
@@Prabasmsoffice Bro Intha Video La Iruka Method Oru Excel la Multiple Sheet la Intha Formula Work Aaguthu ! But Rendu Excel Work Pannumbothu Formula Podra Antha Column la Dhaan Work Aaguthu ! Formula ah Copy Panni Next Row la Pota NA Dhaan Varuthu ! So Work Aagura Maari Oru Video Podunga Please ❤️
The practice file is available in the following link:
www.prabastech.in/free-downloads/
Thank you for wonderful video
Thanks Maeshal for voting Prabas MS Office. Happy learning.
Hi Prabha.. Romba Naal achi video parthu..
Hi Sadha Sivam,
Thanks for your comment, request you to introduce our channel with your best friends.
Haven't you see the message that I sent regarding the last GiveAway?
@@Prabasmsoffice Sure Prabha .. Will do ..last few months I haven't seen any excel videos.. Here after I have to continue ..
sir nenga vera level... nenga solradhu nalla understand agudhu bore adikkala ipdiye sollunga... Thank u so much...
நன்றி. நமது channel ஐ உங்கள் நண்பர்களிடம் பகிர்ந்து கொள்ளுங்கள். கற்க கசடற.
Thanks for your energetic comment. 👍
Sema sir thanks for video
Practice file is also provided in the usual location, utilize it if needed.
Thanks for your comment, request you to introduce our channel with your best friends.
Very Good teaching ...
Hi Sameer, thanks for your comment. Keep learning and supporting.
Thank you very much. Please come out with more such videos. My suggestions you can start an online class for those who want to learn excel. If you already have please let us know how to.
Yes, if you are interested, do let me know.
Contact me @ prabas.msoffice@gmail.com
Thanks sir, your video more use full my job
Thanks for posting your comment, it boost us to post more such videos. Happy learning
Interesting class 🙌
Super explanation 👏👏👏👏👍
Thanks for your comment, request you to introduce our channel with your best friends.
Good one xlookup sample 2 is very nice, and one think iferror super
Thanks for your continuous learning. Happy learning.
very useful thanks sir
Super explanation
Useful video sir
Thanks. I expect the video for XOR function
Sure try to post that too.
Thanks for your comment, request you to introduce our channel with your best friends.
Nice explained...🙏
Very fantastic and detailed explanation sir I learned lot of XL formula's from you thank you. Sir
Super thank you sir
Second one wow very nice.. formula going long. But we reached got answers. Thank you very much 😊❤️❤️
Very Useful video
Great sir
Good explanation in Tamil.
I hope you watch the entire video.
Nice presentation sir🙏
Hi bro, I really loved your videos and it will be very useful for me. the way your are explaining and teaching with an example makes me to understand the concept much better. Keep doing this good work
Glad that you liked it.
Super l like u
Super plz update day or two day one
Sure Selva,
Thanks for your comment, request you to introduce our channel with your best friends.
hi bro i really loved your videos and for same name two unique number is given. how to show in index match at a time for both?
Use a Helper Column by combining your unique value with other data. Then use it in Index match formula.
Thanks sir❤❤❤
Thank you for posting your comment. 👍
nice concept dude. While running the video u ask one question.. what is meaning of #### this error...ii want share wat i know..Genereally this display two concepts such as, that particular cell does not fit value(i.e, if the value was too large) during that time we expand particular cell we get solutions.second one is if we give wrong format like one cell contains under date format means we insert negative value or any wrong data means during that time we face this issue.. finally it is my predication i donwt know wheather this one right or wrong but i want to say what it means we lock T3 cell at the same time we drag formula to all columns t3 is fixed reference . we delted t3 cell values (emp id) so all coulms value depends in t3 cell so it reflects ### error to all coulms at same time dude am i rit?
Sounds good brother...
Thanks for responding and understanding my question....
Ads are coming Good progress bro. Share your bank Account/No I want to give some money
Do you need any personal training requirement?
No bro not possible I m working
Super
Happy learning.
My output results is #N/A pls help me ( 2and big table ).. here I am correctly following ur instructions
Bro iferror function it's not working for sum conditions,
Ex:
=Iferror (sum(range: range),"")
Sir. Good. I have a doubt. The name is one more same Indra. How to do Chech from task 2
If you have any second instances, you have to use the * Advanced Lookup* option, watching the following video can tech you the trick:
ua-cam.com/video/dqgJbpcW0PA/v-deo.html
I need advance macro personal training requirement
Sir,
How to create indication alarm (pass/fail) number instead of letters?
Ex.
abcdef - pass
0gh3hy - fail
Ghjjjfy - pass
34ghy6 - fail
Sir,
In the same concept how set the indication alarm (pass/fail) letter instead of number?
Example - 123456 - pass
345726 - pass
12b45a - fail
c323h6 - fail
Hello sir,
I am awaiting for your reply
My recommendations below:
1. VLOOKUP
2. If condition
Let me know if my recommendations are confusing
@@Prabasmsoffice sir,
Pls send the formula to me
Sir,
I have tried if function with some formula but indication will not not come, so that pls send both (letter inseated of number & number instead of letters) indication formula to me
Bro Orey Sheet la Formula Pota Work Aagaathu ! Idhu 2 Excel la Formula Pota NA Dhaan Varuthu
I will make a new video for this, stay tuned.
@@Prabasmsoffice Bro Intha Video La Iruka Method Oru Excel la Multiple Sheet la Intha Formula Work Aaguthu ! But Rendu Excel Work Pannumbothu Formula Podra Antha Column la Dhaan Work Aaguthu ! Formula ah Copy Panni Next Row la Pota NA Dhaan Varuthu ! So Work Aagura Maari Oru Video Podunga Please ❤️
Noted
@@Prabasmsoffice Tq Bro Seekram Podunga Video ! Enaku Use Aagum Bro
Iferror formula
iferror formula
it doesnt work when i work with two sheet. :/
It has to work brother, screenshot please.
Have you watched the entire video?
Whole Microsoft Excel Sheet, Formulas adjustment any ideas in one Video Click.
It is possible,
We can create macros for your custom requirement.