Excel Filter Function | How to use Filter Function in Excel | Dynamic Arrays

[@Baloon150blue]

Best teacher in the world ❣

[@eighttech]

U r only best Excel techcher in india ❤

[@Innozant]

Thanks..Really means a lot to me.Keep Growing

[@rajeevranjan2478]

Really good sir

[@nevermore_ind]

Best excel tutorial channel

[@pahadibhula]

Very informative video sir,,, bahut hi saral shabdo me explain Kiya aapne

[@Innozant]

Thanks

[@javedahmed8343]

What a step by step explanation! Great work

[@Innozant]

Thanks Javed ji..Keep learning ❤️

[@sandeepaswal8944]

Sir aapnai bahut hi achai sai samjaya maja aagya yai shikhar Thank you so much sir ❤

[@Innozant]

Thanks Sandeep Ji..Happy Learning dear🙏❤️

[@shaileshjha6623]

Nicely explained

[@1gopalakrishnarao]

Excellent. Your explanation is very informative, inspiring & very easy to learn. Thanks a lot on behalf of all my Excel learners/users/addicts.

[@Innozant]

Thanks Gopala.. Happy Learning.❤️🙏

[@satishojha6240]

Thanku for dynamic filter sir 🙏🙏🙏.good night

[@Innozant]

Thanks Satish Ji..Hope u like

[@satishojha6240]

@@Innozant off course sir aisa bolkar sharminda mat kijiye aaj aap ki wajah se mere bohut se kam chutkio mai ho jatye hai. 🙏🙏🙏🙏🙏🙏

[@mahmedmalang6947]

Very good performance in excel Tips n short cut.

[@Innozant]

🙏❤️thanks

[@jayantabhattacharyya628]

Dear Sir Excellent filter function in excel 365. Before watching this video, I don't know the varieties of filter function. Thanks for uploading such a important video Thanks & Regards Jayanta Bhattacharyya

[@Innozant]

Thanks Jayanta .Happy Learning ..More examples are coming soon😊🙏❤️

[@arvindthapliyal1639]

Very nicely explained

[@manojkumarsingh3385]

Excellent Features Sir 🙏🙏🙏

[@Innozant]

Thanks dear🙏

[@deshraj2110]

Very very helpful, you are great sir

[@Innozant]

Thanks Desh Rak❤️🙏

[@sanjivpandey9406]

Sir kyu na drop down me aap unique function use karke combine kar dete to mast ho jata learning aur bhi. Apke videos ne boht help kia hai.

[@Innozant]

Very true..Sanjiv ji..aap to jante hain main harek playlist in sequence step by step bnata hu jisse sabko samajh aaye..Apko abhi filter unique sabhi function ke kai roop rand dekhne ko milenge dear❤️🙏🙏

[@sajjadhussain3899]

WOW... THANK U SO MUCH SIR.....GOD BLASE YOU.

[@Innozant]

Thanks Hussain sahab❤️🙏

[@BharatiyaFirstThanHinduMuslim]

Sir aap mast ho 🤘

[@createyour6681]

Very great sir

[@Innozant]

👍❤️

[@kalwantsingh4997]

ज़बर्दस्त sirg

[@Innozant]

Thanks

[@hsgusain2054]

Very nice sir🙏🙏🙏

[@Innozant]

Thanks Gudain Sahab❤️🙏

[@koushik4484]

Excellent job. 👍 How to get filter with multiple summarise data from a table of loaded data. For example - In the above table, how much total score of A,B and C. Pl. be explained.

[@naeemulhassan1426]

Sir Ur tutorials are very excellent and ur teaching style as well. Kindly let us to know about difference filter and advance filtet.? Stay Bless and take care .

[@Innozant]

Thanks..Kindly watch ,there is seprate playlist For filter and adv filter

[@tejpalsain1507]

Great sir.

[@Innozant]

Thanks Tejpal❤️🙏

[@khalidalisubhanallah2947]

Super Sir g 💟

[@Innozant]

Thanks Khalid sahab🙏❤️

[@kishorpanara4191]

I like it & thank you sir

[@Innozant]

Thanks Kishor ji🙏❤️gn

[@camehak6143]

Nice one ! If I want to pick A & B both in descending sort, how can I use that

[@pradeepjangid490]

Great sir

[@Innozant]

Thanks Pradeep Ji🙏❤️

[@rohanparakhe4976]

Thank you sir.please Start VBA macro series

[@Innozant]

After power Series dear.

[@rohanparakhe4976]

@@Innozant thanks sir.but data analyst skills required pe video banaye.please

[@Innozant]

👍

[@tayyabraza4303]

awesome

[@gauravbhatia7987]

Good 🙏

[@Innozant]

Thanks Gaurav🙏❤️

[@timesavertricks]

@innozant Sir Can this function only extract data of specific multiple columns from large dataset. Same like we can extract using advance filter

[@azhadshamim3122]

Sir How to get deta from other sheet through Filter farmula?

[@1050jeet]

Nice informative video..just a quick question... I could have practiced but not using this version.. question is how to manage OR criteria like I want to filter A and C items at the same time..instead of sumproduct can we use (criteriarange1="a") + (criteriarange1="b")

[@BalvirSingh-qs9kz]

Sir, a b c ko heading banaye fir name ke samne score ko filter karakar next video banaye. Thanks

[@Maya-c5n]

Sir number pe work karega?

[@a.k.prajapati2469]

Alphanumeric data ko kese filter kr sakte hai?? Jese F1 F2 A22 A2 C01 C11 C12 C03 C130 F32 ese data ko chronological order me kese fit krenge??

[@kirankumaryadav2516]

Ex if we have times in columns like 34:34:43, 46:57:54, 12:32:56, 44:56:32, 08:45:46 and they are in time format. I want to get result using IF function as for greater than 24 hours to come as "Beyond time" and less than 24 hours as "Within time". Please text the formula and reply sir

[@Innozant]

Kiran maine btata tha aapko nested if use karen..ya sheet share kren ap will help you

[@swadealhadecooking5587]

Sir Date format output show korche na Value show korche Format cell theke hochhe Please solve problem🙏🙏

[@manojkumarsingh3385]

🙏🙏🙏🙏🙏

[@sunilyadav4]

Sir isme wildcard laga sakte hai kya

[@Innozant]

Wait kijiye aapko iske kai roop rang dekhne ko milenge

[@rajibehsan3503]

how to get filter function in excel 2016& 2019

[@ananthkumarkn2599]

hi sir myne ek company me kaam kar raha hu mujhe daily same data filter karke data seperate karna hi bahuth time waste ho raha hai app help kar sakthe hi kya

[@faisalmd283]

Hi sir, small doubt in excel, why do we get blank in the pivot table when their is no blank in the data. and the same when we filter data blank will be shown but actually their is nothing like that. I would request you to tell why it reflects and how to remove blanks. Thanks in anticipation.

[@Innozant]

It usually happen when theerw is blank area in source data,there are lots of method to remove blank ..using goto special or using pivot table design..-remove blank rows... Even using filter you may remove blank

[@naman881]

Sir, aapka video dekha "rank" vala, problem ye hai ki agar rank same ho to jugaad karke hum countif aur minus 1 laga dete hai aisa karne se niche vale person ka rank mil jata hai . But mujhe chahiye ki do ya jyada person ki rank same hone par koi aur criteria k through rank liya jai jaise person k salary ya age etc lekin keval unhi personka jinka rank same ho , shayad if formula se ho jaye Please reply sir! Mai basic excel sikh raha hu aapke channel se isilye latest video par comment karke pucha

[@Innozant]

Kuch din baad jab aap sumproduct topic par pahucengr to khud answer mil jayega ..RANK IF video hoga usmr

[@sayeedshaik573]

Sir waiting for interview tips videos 💔😞

[@jitendrapatil7554]

अच्छा है लेकिन् अगर मेरे पास अलग अलग स्टेट (State) हो और उनका डेटा एक से दो साल के अलग अलग तारीख के बीच का डेटा फिल्टर करना हो और उसमे स्टेट और तारीख दोनो ही फिल्टर होके दिखे तो कैसा करना होगा. Plaz बताये

[@naseemakbar6962]

Ye to shayad vlookup se bhi hosakta hai

[@pankajloya5521]

Mere excel me filter funtion nai aa raha he kyu???

[@Innozant]

Office 365 version me available hain ye functions

[@manojkumarsingh3385]

Sir Maine aap se ek problem share Kiya tha Agar Hum number Likhe to o alphabet me convert ho Jaye Jaise BIMJKSUPXY B=1 I=2 M=3 12565= BIKSK

[@Innozant]

Explain your query .. 12- Tweleve ye aana chaiye?

[@manojkumarsingh3385]

@@Innozant 🙏🙏🙏 Sir Hume Kisi item Ka price likhna ho to code me ho Jaye Example - 125 rupees = BIK Write in words me number ko convert jis Tarah Kar dete hai usi Tarah ye kam kare lekin code word me Jaise 1=B 2=I 3=M 4=J 5=K 6=S 7=U 8=P 9=X 0=Y Agar Kisi item Ka price 790 Rupees ho to O convert ho Kar PXY me likh Kar aa jaye

[@Innozant]

Using char and code bna skte hain..but ramdom chaiye yabye fix hoha 1-A ,2-B etc?

[@manojkumarsingh3385]

@@Innozant 🙏🙏🙏 No sir jis Tarah Maine code likh Kar aap ko diye hai usi Tarah tally prime ke Dwara print hits hai Jisme 1 ke liye B, 2 ke liye I,3 ke liye M, 4 ke liye J, 5 ke liye K, 6 ke liye S, 7 ke liye U, 8 ke liye P, 9 ke liye X, 0 ke liye Y. Agar item Ka selling price 31965 rupay ho to uska bar code me price MBXSK print hoga Please help sir 🖥️🖥️

[@ubaidillahmuhammad20]

Download File for Practice -Direct Link Updating soon. WHERE IS IT?

[@Innozant]

Already updated

[@robin918]

I want the name of those studenta who belong to A,B then how will do this?

[@Nandu_comedy2]

Sir apna number de dijiye hamko aap se bat karna or excel padna h aap se

[@Innozant]

Good Morning Shiv,KZbin ke about section me bhi hsi contact number aur Innozant ke website se leke aap WhatsApp kijiye course detail send kar diya jayega aapko ya aap aona number share karer @innozantofficial telegram id

[@chandandasy2k10]

=IFERROR(INDEX($F$7:$F$21,MATCH(0,COUNTIF($H$6:H6,$F$7:$F$21),0)),"") sir if you explore this formula it will very helpful to me. i cant understand the formula how it internally works.this is an unique value list formula.

[@Innozant]

Its veru simple chandan..You may confused with Match (0 Kindly note that we are looking for false value in lookup array .Kindly watch this video ,I already explained this

[@kamleshshrivastava976]

ye formula 2019 me nahi hai

[@Innozant]

Nahi .office 365

[@manojkumarsingh3385]

Please Help sir