Thank you so much sir. The advance filter 1-5 sessions were extremely beneficial. Your clear instructions, use of understandable language and examples make the tutorial captivating and useful. Stay blessed! Keep uploading more videos.
Thank you sir, your videos are very helpful I just had a question about this video, what's the difference between pivot table and filtering? It seems like they both have the same use..
sir is it possible on excel to ONE word for ONE CELL ?????????? and another word when i try to type it is shifted to other cell??????????? PLEASE REPLY ME SIR
एक row के अंदर कुछ समान नंबर है, उनके सामने वाली row में उनसे संबंधित नंबर है तो क्या ऐसा फ़िल्टर लगाया जा सकता है कि केवल सबसे बड़े वाले नंबर को रख लिया जावे। जैसे no 5 row में 10 बार आया है व सामने वाली row में 1, 2, 3, 4,5,6,7,8,9,10 है जब ऐसे डाटा हो तो कोनसा फ़िल्टर लगेगा।
But suppose I am sorting this data and I want the highest ROI and highest Cost data. That is the only criteria I have for the advanced filter but I don't want to pass the value as criteria, I want excel to understand the highest ROI and Highest Cost value in the data and give me results. How this can be done then? Region (User location) Cost ROI Bihar 1,509,191 8% Uttar Pradesh 809,337 -3% Karnataka 744,634 8% Delhi 683,904 5% Telangana 615,799 5% Gujarat 498,778 -3% Tamil Nadu 489,825 7% West Bengal 406,740 -2% Haryana 358,212 0% Rajasthan 336,795 -1% Madhya Pradesh 313,659 9% Maharashtra 291,503 -7%
But suppose I am sorting this data and I want the highest ROI and highest Cost data. That is the only criteria but I don't want to pass the value to the value, I want excel to understand the highest ROI and Cost value in the data and give me results. How this can be done then? Region (User location) Cost ROI Bihar 1,509,191 8% Uttar Pradesh 809,337 -3% Karnataka 744,634 8% Delhi 683,904 5% Telangana 615,799 5% Gujarat 498,778 -3% Tamil Nadu 489,825 7% West Bengal 406,740 -2% Haryana 358,212 0% Rajasthan 336,795 -1% Madhya Pradesh 313,659 9% Maharashtra 291,503 -7%
How to filter numbers contains a particular nth digit. Say : 134543 724654 985675 874609 The 3rd from left of every no contains ' 4 ' needed to filter. How,?
I have a question. Suppose There are 8 sales man who went to advertise their product to different location. And they have individual ID which are AT-001, AT-002, AT-003, AT-004, AT-005, AT-006, AT-007, AT-008. The have totally sold 5000 sales. I want to find each ID's count of sales. And there is a condition which is, I will collect only 100 sales from each ID's and shall not be more then 100. If any ID sold only less then 100 products, still it will be included but if there is over 100 then it will filter the data and give me only 100 product sales data. Kindly tell me how to do it? Is there any formula or I can just use advanced filter option to create it? Help Me.
Hi sir, Greetings..! I would like to learn more about excel, actually I worked as a ghee distributor business accountant,so how to maintain in excel. Please share with me excel format Like including purchase, sales, commission, payment due ,& stock in hand more...
Hello Bro, @ 2.17 all 4 rows containing the keyword West is selected, however why midwest isnt selected. 1. what is the formula to extract west frm midwest and display separately. 2. Or how to extract west from a sentence in a row and display separately. Kindly teach me how to do this. thnq v much
Nice explanation. I'm new here I subscribe. My question is when using excel if data the is to long go to A to z already how can you print it? I mean can you break it into half to make it 2 print papers?
hello Mr Pavan . I have a source of about 25k items. i have another list of 200 items that match with 25k list. Now i want to filter those 200 items from 25k list . Can you please advise how to do ?
Sir, i am a new learner to excel and your way to deliver your words is really awesome, very simple, understandable specially belongs to Hindi educational background. Thanks
THANK YOU SIR, SIR I HAVE A PROBLEM I AM WORKING IN BUILDERS AND CONSTRUCION COMPANY WHICH PROVOIDE MONTHLY INSTALLMETS SCHEDULE, IN WHICH MANY OPTIONS LIKE MONTHLY, HALF YEARLY, YEARLY, QUATARLY, ETC I WANT TO MAKE A SHEET WHICH I PUT ALL THEASE VALUE AND ITS MAKE 48 MONTHS INSTALLMENT PLAN
I have multiple enteries of expenses like maintence, shopping, grocery in one sheet and i want all data except grocery, so which formula can i use to get the exect data without using filter?
For your teaching style is very well, easy to understand what you try to say, Thanks for the sharing your knowledge, Surely it will use full for who is actually needed about excel like me.
I have a table of data and a 2 list of values for 2 separate columns on which on want to filter. I want to include the value for one list of data in one column and exclude the values for the other list in 2nd column of the table. How can I achieve this..
onadvance filtering - a set of numeric data., it become automatically sorting in ascending order......for eg i want result data 3, 6,7,1, 2.....the result data gives 1,2,36,7,,,,,,,,how can i get the data as 3,6,7,1,2
I'm trying advanced filters, but not getting data properly........ The result operation will same as like copy and past, filter operation couldn't perform properly need assistance
Sir could you please tell me the benefit of this function?instead of using the advance filters we can do it with simple filters also.so please clarify the difference between them.
Plz let me know if I use "Sumif Formula* in report sheet (sheet 1 ) , when I filterer my data in data sheet(Sheet 2 ) sumif formula must pick (Sum) only faltered data. is it possibly??? Plz reply .