All your videos are very good. I have one question here. In production company many styles are produced in different lines. In reports, we are entering stylewise. Suppose in any case, in a particular given date, if we need all styles produced means how to get the report. Simply how to convert stylewise into date wise. A style runs to 1 or 2weeks.
Broo...ithuku instead of match and vlookup use pannalam...I tried with Index and match also...after watching ur tutorials....Index and match so powerful 😁😁😁😁
Hi bro please upload multiple excel sheet making a chart example (total sales, Delivery sales,Counter sales,wastage,sales average) by using all to make chart thank you
Bro ippo vlookup formula use panni sheet 1 la iruka data va sheet 2 ku konduvaruvom apadi pannuthuku aparam sheet 1 close pannita sheet 2 la lookup value edutu vandha data not applicable or error nu varum atha epadi bro solve pandrathu enaku sheet 1 la irundhu sheet 2 ku lookup value vandha piraghu sheet 1 ah close panna andha data apadiye irukanum athuku oru solution iruka bro
sir clear my problem i want more results in different cells from that particular look up value like 2 or more results from each region but name is one only.
Bro Recipe Multiple Results Ebdi Therinjika﹖ e.g. Wheat Flour 0.215g+Oil 0.03ml=Chapathi 6Nos Per Head (Result Manually Already Inserted), 48 Head Ku Result﹣A Mattum Maathura Function Enna Adhu pathi Oru video podunga Plz
Sir I have same issue with my work a cell having multiple characters i need to lookup for the agents name but if i do vloop i don't get the output for those cells have multiple character and thetr solution for that and its time consuming work please help me sir
வணக்கம் அய்யா... நான் உங்களுடைய எக்செல் விடியோ பார்த்து வருகிறேன்.. நான் coop auditor aga உள்ளேன்.. எனக்கு audit reports ஐ Excel use பண்ணி நானே ready pananum nu oru aim..(computer centre la kodukamal). So எனக்கு கொஞ்சம் ideas koduThu உதவ முடியுமா...?
How to pick up if a salesman has saled different products in same region.Even though the salesman sold different products, I was shown only one and not more than that.
SIR PLEASE DO THIS SAME LOGIC AT NEXT SHEET( AFTER I SAW YOUR VIDEO I GO TO INTERVIEW) BUT AVANGA COMBINE PANATHA NEXT SHEET LA PODU VLOOKUP PANI KODUVARA SOLURAGA I WAS STRUGGLE TO DO PLS HELP ME AND POST THE DOUGHT.
When We are selecting the look up value , why can't we select the helper desk column alone ?why are you using again those concatenate all those things bro
Sir, I have a doubt, I would like to change months name. But right now I have January February March 4 5 6 7 8 9 10 11 12. I DON'T KNOW how to change it, Kindly assist me, Regards Velu
My friend you can use =TEXT(DATE(2022,A1,1),"MMMM") and In this formula "A1" is the reference to the cell containing the month value you want to convert
Don’t Forget to Follow:
twitter.com/EndlessKnowled1
facebook.com/enlessknowledge
instagram.com/end_less_knowledge
VERY GOOD EXPLANATION. clarified cell references also. thank you!!
This video has created some sparks in me and made me to have more confident to work on excel with different criteria without any hesitation.
Glad to hear that brother... Keep learning more about Excel ruclips.net/p/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh
your teaching is really awesome, which helped me in finding out an error and rectified myself..Hats off Bro!!
Finally found the GOAT. Thanks a lot ❤
பெரிய மனசு sir உங்களுக்கு தெரியாதவர்களுக்கு share பன்னுங்கன்னு சொல்றது.. சூப்பர் ....
Yes, everyone deserves to know everything...
@@EndlessKnowledge Endless Knowledge for Endless People
Love you always sir... Your explanation was ulti....
Thanks a ton...
Superb, I like very much for your teaching method, kept it up
thanks, i will... Keep watching more videos...
All your videos are very good.
I have one question here.
In production company many styles are produced in different lines.
In reports, we are entering stylewise.
Suppose in any case, in a particular given date, if we need all styles produced means how to get the report.
Simply how to convert stylewise into date wise.
A style runs to 1 or 2weeks.
Broo...ithuku instead of match and vlookup use pannalam...I tried with Index and match also...after watching ur tutorials....Index and match so powerful 😁😁😁😁
lot of ways are there nanba...Great 👍
@@EndlessKnowledge ❣❣❣
Super bro really useful thank you
Really good. Thank you for the practice file.
yes, explanation is too good, it did spark off , still need to practice . any chance of one to one, just to ensure what iam doing is right?
Super Sir Really Use full 👌
glad it was useful to you...
Thanks Bro. vlookup almost dead with xlookup. Due to compatibility issue still vlookup alive
Useful video anna 👌🙏
glad it was useful to you nanba...
ஐயா, விண்டோஸ் எக்ஸ் எல்7ல் பத்து அடிமான முறையை 12 அடிமானம் முறையாக மாற்றும் முறை சொல்லுங்கள்.
Super video very detailed
1st view 1st comment 1st like
Ungalukku naan first like 😜
@@RamKumar-gs3tz ungaluku na 1st like and firest comment
🎉
Super BRO 👌
Thanks nanba... keep watching my friend...
Hi bro please upload multiple excel sheet making a chart example (total sales, Delivery sales,Counter sales,wastage,sales average) by using all to make chart thank you
Will upload soon my friend...
Really thank you soo much bro
Hai sir excel irukura all database format Ellathaiyum word la eapdi print or work eapdi pannurathu pls sollunga sir
Bro ippo vlookup formula use panni sheet 1 la iruka data va sheet 2 ku konduvaruvom apadi pannuthuku aparam sheet 1 close pannita sheet 2 la lookup value edutu vandha data not applicable or error nu varum atha epadi bro solve pandrathu enaku sheet 1 la irundhu sheet 2 ku lookup value vandha piraghu sheet 1 ah close panna andha data apadiye irukanum athuku oru solution iruka bro
Sir deivam sir neenga
Thank you 🙏
I am glad you found the video useful!... Keep learning more about Vlookup ruclips.net/p/PLLHRrAfRqTbMyHKoEvVZa6Bas2XHX-yys
sir clear my problem i want more results in different cells from that particular look up value like 2 or more results from each region but name is one only.
well teaching
Thanks...
Bro enaku oru doubt nambadan helperla name region sethu kanupidichachu apram yen taniya formula podanum
Bro, can you please share about Sumif and Vlookup Combination video
Bro , epadi files download panni work pandrathu bro pls slunga bro pls
Appreciated sir
I am from Karnataka,don't know Tamil.My son talks fluent. But your sweet pronunciation is make undurstant me sir.
Bro Recipe Multiple Results Ebdi Therinjika﹖
e.g. Wheat Flour 0.215g+Oil 0.03ml=Chapathi 6Nos Per Head (Result Manually Already Inserted),
48 Head Ku Result﹣A Mattum Maathura Function Enna
Adhu pathi Oru video podunga Plz
Sir I have same issue with my work a cell having multiple characters i need to lookup for the agents name but if i do vloop i don't get the output for those cells have multiple character and thetr solution for that and its time consuming work please help me sir
Suprp..👍
thanks ...
Thank you
வணக்கம் அய்யா... நான் உங்களுடைய எக்செல் விடியோ பார்த்து வருகிறேன்.. நான் coop auditor aga உள்ளேன்.. எனக்கு audit reports ஐ Excel use பண்ணி நானே ready pananum nu oru aim..(computer centre la kodukamal). So எனக்கு கொஞ்சம் ideas koduThu உதவ முடியுமா...?
Hi bro
Please tell
If and if error with vlookup condition
hey nanba... watch this ruclips.net/video/W6M-SipvTTQ/видео.html
Vlookup neenga soldra mari than pandren bt work aga matithu konja eppadi pandrathu sollunga bro
How to pick up if a salesman has saled different products in same region.Even though the salesman sold different products, I was shown only one and not more than that.
We need learn formultiple certeria with particial text vlookup in excel
Sir wilcome software padhi therichikanum aasa sir adha padhi solla mudiuma sir
will try that soon...
@@EndlessKnowledge thanks sir 🥲.....I hope you do 💯
@8.05 HOW TO INSERT DROP DOWN BUTTON AND SELECT MULTIPLE NAME IN SINGLE CELL
Regionla yalla totalum yan varala
South region apdina
South regionla ulla yalla totalum yan total aagala
HOW TO MAKE THE RIGHT SIDE BLUE TABLE WHERE YOU USE FORMULA PLS PUT AN TUTORIAL ON THAT.
Bro, file to file data select formula explain pls
Thank you sir
your most welcome...
Bro update full Excel course one video to learn
Anna pls make video automatic ✓ mark, once double click enable tick mark Again double click uncheck the tick mark option
have you watched this nanba...ruclips.net/video/AJy__dbn0Fc/видео.html
SIR PLEASE DO THIS SAME LOGIC AT NEXT SHEET( AFTER I SAW YOUR VIDEO I GO TO INTERVIEW) BUT AVANGA COMBINE PANATHA NEXT SHEET LA PODU VLOOKUP PANI KODUVARA SOLURAGA I WAS STRUGGLE TO DO PLS HELP ME AND POST THE DOUGHT.
Sir why should they have a helper column?
Tnx...
When We are selecting the look up value , why can't we select the helper desk column alone ?why are you using again those concatenate all those things bro
nanba could you mention those timestamps?
I'm also have same question. Sir Pls explain briefly, that why not using helper clmn
Thanks
Welcome... Keep learning more about Excel ruclips.net/p/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh
How to calculate last three month or five month trends in report?. Thanks
PO tracker video poduga Bro
index match use panna time save agum bro
How to get sample data for practise
Why no reference to Pivot table usage?
several way are there my friend like you said Pivot Table, Index match, Vlookup choose and even xlookup... i tried to make it short that's it nanba...
Arumai sir
Enaku - la results varudhu y anna?
Anna
Please upload Excel Power Query
soon nanba...
Sir,
I have a doubt,
I would like to change months name.
But right now
I have
January
February
March
4
5
6
7
8
9
10
11
12.
I DON'T KNOW how to change it,
Kindly assist me,
Regards
Velu
My friend you can use =TEXT(DATE(2022,A1,1),"MMMM") and In this formula "A1" is the reference to the cell containing the month value you want to convert
Vlookup formula la mistakes katithu brother i can't find the error
Sir f 4 kudatha lock angamatuthu sir
Excel online course sollitharingla
Sir pls context no sir one doubt sir pls
எங்க ப்ரோ helper coulm அதைத்தான் hide பன்னிங்க items coulm எங்க ப்ரோ
i didnt get ans bro dont know y
Minus
Anna these video I can't understand is too hard
thank you sir