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

Excel Filter Function | How to use Filter Function in Excel | Dynamic Arrays
Office 365 Playlist Link- • Office 365
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.com/courses/adv-...
✅ Mastering Power BI Video Course
www.innozant.com/courses/powe...
✅ Mastering VBA Video Course
www.innozant.com/courses/vba-...
✅ Mastering SQL Video Course
www.innozant.com/courses/orac...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozantinfotech
#filterfunction #filterinexcel#innozant #office365

[@javedahmed8343]

What a step by step explanation! Great work

[@Innozant]

Thanks Javed ji..Keep learning ❤️

[@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.❤️🙏

[@nevermore_ind]

Best excel tutorial channel

[@rajeevranjan2478]

Really good sir

[@camehak6143]

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

[@arvindthapliyal1639]

Very nicely explained

[@manojkumarsingh3385]

Excellent Features Sir 🙏🙏🙏

[@Innozant]

Thanks dear🙏

[@deshraj2110]

Very very helpful, you are great sir

[@Innozant]

Thanks Desh Rak❤️🙏

[@eighttech]

U r only best Excel techcher in india ❤

[@Innozant]

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

[@sajjadhussain3899]

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

[@Innozant]

Thanks Hussain sahab❤️🙏

[@mahmedmalang6947]

Very good performance in excel Tips n short cut.

[@Innozant]

🙏❤️thanks

[@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")

[@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😊🙏❤️

[@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

[@timesavertricks]

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

[@kishorpanara4191]

I like it & thank you sir

[@Innozant]

Thanks Kishor ji🙏❤️gn

[@sandeepaswal8944]

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

[@Innozant]

Thanks Sandeep Ji..Happy Learning dear🙏❤️

[@BharatiyaFirstThanHinduMuslim]

Sir aap mast ho 🤘

[@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❤️🙏🙏

[@tejpalsain1507]

Great sir.

[@Innozant]

Thanks Tejpal❤️🙏

[@kalwantsingh4997]

ज़बर्दस्त sirg

[@Innozant]

Thanks

[@createyour6681]

Very great sir

[@Innozant]

👍❤️

[@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. 🙏🙏🙏🙏🙏🙏

[@pradeepjangid490]

Great sir

[@Innozant]

Thanks Pradeep Ji🙏❤️

[@hsgusain2054]

Very nice sir🙏🙏🙏

[@Innozant]

Thanks Gudain Sahab❤️🙏

[@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??

[@khalidalisubhanallah2947]

Super Sir g 💟

[@Innozant]

Thanks Khalid sahab🙏❤️

[@gauravbhatia7987]

Good 🙏

[@Innozant]

Thanks Gaurav🙏❤️

[@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]

👍

[@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

[@manojkumarsingh3385]

🙏🙏🙏🙏🙏

[@swadealhadecooking5587]

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

[@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

[@sunilyadav4]

Sir isme wildcard laga sakte hai kya

[@Innozant]

Wait kijiye aapko iske kai roop rang dekhne ko milenge

[@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

[@naseemakbar6962]

Ye to shayad vlookup se bhi hosakta hai

[@sayeedshaik573]

Sir waiting for interview tips videos 💔😞

[@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

[@jitendrapatil7554]

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

[@manojkumarsingh3385]

Please Help sir

[@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

[@Comedy_video9415]

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

[@ubaidillahmuhammad20]

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

[@Innozant]

Already updated

[@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 🖥️🖥️

[@kamleshshrivastava976]

ye formula 2019 me nahi hai

[@Innozant]

Nahi .office 365

[@pankajloya5521]

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

[@Innozant]

Office 365 version me available hain ye functions