Excel Filter Function | How to use Filter Function in Excel | Dynamic Arrays
HTML-код
- Опубликовано: 25 авг 2024
- 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.c...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
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/innozanti...
#filterfunction #filterinexcel#innozant #office365
U r only best Excel techcher in india ❤
Thanks..Really means a lot to me.Keep Growing
Best excel tutorial channel
ज़बर्दस्त sirg
Thanks
Really good sir
What a step by step explanation! Great work
Thanks Javed ji..Keep learning ❤️
Sir aapnai bahut hi achai sai samjaya maja aagya yai shikhar Thank you so much sir ❤
Thanks Sandeep Ji..Happy Learning dear🙏❤️
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.
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❤️🙏🙏
Excellent. Your explanation is very informative, inspiring & very easy to learn. Thanks a lot on behalf of all my Excel learners/users/addicts.
Thanks Gopala.. Happy Learning.❤️🙏
Very good performance in excel
Tips n short cut.
🙏❤️thanks
Very nicely explained
Very very helpful, you are great sir
Thanks Desh Rak❤️🙏
WOW... THANK U SO MUCH SIR.....GOD BLASE YOU.
Thanks Hussain sahab❤️🙏
Great sir
Thanks Pradeep Ji🙏❤️
Excellent Features Sir 🙏🙏🙏
Thanks dear🙏
Very great sir
👍❤️
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
Thanks Jayanta .Happy Learning ..More examples are coming soon😊🙏❤️
Sir aap mast ho 🤘
Thanku for dynamic filter sir 🙏🙏🙏.good night
Thanks Satish Ji..Hope u like
@@Innozant off course sir aisa bolkar sharminda mat kijiye aaj aap ki wajah se mere bohut se kam chutkio mai ho jatye hai. 🙏🙏🙏🙏🙏🙏
Good 🙏
Thanks Gaurav🙏❤️
I like it & thank you sir
Thanks Kishor ji🙏❤️gn
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 .
Thanks..Kindly watch ,there is seprate playlist For filter and adv filter
Great sir.
Thanks Tejpal❤️🙏
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.
Very nice sir🙏🙏🙏
Thanks Gudain Sahab❤️🙏
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??
Super Sir g 💟
Thanks Khalid sahab🙏❤️
Nice one ! If I want to pick A & B both in descending sort, how can I use that
@innozant Sir
Can this function only extract data of specific multiple columns from large dataset.
Same like we can extract using advance filter
Thank you sir.please Start VBA macro series
After power Series dear.
@@Innozant thanks sir.but data analyst skills required pe video banaye.please
👍
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")
Ye to shayad vlookup se bhi hosakta hai
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
Sir
Date format output show korche na
Value show korche
Format cell theke hochhe
Please solve problem🙏🙏
अच्छा है लेकिन् अगर मेरे पास अलग अलग स्टेट (State) हो और उनका डेटा एक से दो साल के अलग अलग तारीख के बीच का डेटा फिल्टर करना हो और उसमे स्टेट और तारीख दोनो ही फिल्टर होके दिखे तो कैसा करना होगा.
Plaz बताये
🙏🙏🙏🙏🙏
Sir isme wildcard laga sakte hai kya
Wait kijiye aapko iske kai roop rang dekhne ko milenge
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
Kuch din baad jab aap sumproduct topic par pahucengr to khud answer mil jayega ..RANK IF video hoga usmr
Sir waiting for interview tips videos 💔😞
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.
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
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
Kiran maine btata tha aapko nested if use karen..ya sheet share kren ap will help you
Please Help sir
Download File for Practice -Direct Link
Updating soon. WHERE IS IT?
Already updated
Sir apna number de dijiye hamko aap se bat karna or excel padna h aap se
Good Morning Shiv,RUclips 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
ye formula 2019 me nahi hai
Nahi .office 365
=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.
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
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
Explain your query ..
12- Tweleve ye aana chaiye?
@@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
Using char and code bna skte hain..but ramdom chaiye yabye fix hoha 1-A ,2-B etc?
@@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 🖥️🖥️
Mere excel me filter funtion nai aa raha he kyu???
Office 365 version me available hain ye functions