Excel Advanced Filter Tricks (10 Awesome Tricks) | Vivekananda Sinha | Video 155
HTML-код
- Опубликовано: 8 июл 2024
- Excel Advanced Filter Tricks (10 Awesome Tricks)
Data Filtering is one of the common task that we use while working on Excel Reports. Most of us use the Auto Filter option of Excel. But there are complex criteria where Auto Filter is not capable of filtering the data. In this tutorial, I will show you 10 different scenarios to do filter using Advanced Filter option in Excel. The trick shown will work across all versions of Excel. Be it Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365.
00:00 Start
01:12 Filter Text with Advanced Filter
07:20 Filter Numbers with Advanced Filter
09:51 Filter Dates with Advanced Filter
11:44 Use of Wildcards in Advanced Filter
14:02 Advanced Filter using Complex Criteria
20:23 Fetch Unique List with Advanced Filter
★ My Excel Bundle Course ► futureinhands.com/microsoft-e...
⯆ Download the file here: futureinhands.com/youtube/ass...
In this Excel tutorial we cover a few important topics rather quickly:
What are the challenges in Auto Filter
How to setup Advanced Filter
How to use the criteria range in Advanced Filter
How to setup your criteria to filter for OR / AND conditions
How to filter from a List of Text with Advanced Criteria
How to filter between two dates or two numbers with Advanced Filter
How to use wildcards in Advanced Filter
How to filter using Complex Criteria
How to get a list of unique values
★ MUSIC IN THIS VIDEO
Music by / ikson
★ Let’s connect on social:
Our Telegram Group: fih.one/club
My LinkedIn Profile: fih.one/vs-linkedin
My Facebook Profile: fih.one/vs-facebook
Our LinkedIn Page: fih.one/linkedin
Our Facebook Page: fih.one/facebook
#FutureInHands #VivekanandaSinha #MicrosoftExcel #MicrosoftOffice
This single video is very helpful to understand the different requirements in the filtration process. Thanks🙏🙏.
By this video I have learned new things in advanced filter. Thank you sir
Very useful .Thanks a lot.
Really helpful Sir 😊
Awesome Video Sir..
Awesome tricks
Superb
Awesome sir
Thanks sir
it was awesome video sir, you have very interesting way teaching.. really helpful..🙏
Thank you so much Rana ji. 🙏
Hello Sir, I have to create a separate file for email attachment as per team leader program wise but there is multiple sheets in single workbook, can be possible to separate all the sheets as per team leader wise.
It is possible. Maine tutorial already create kiya huwa hai. Split search kijiye
सर एडवांस्ड फ़िल्टर से एक्सट्रेक्टेड डेटा rearrange कॉलम कैसे कर सकते है?
Department ID Name .....
Kar sakte hai. Jis order me chahiye us columns ko likh dijiye blank range me. The advanced filter me copy to range me is range ko select kar dijiye
@@Futureinhands Thanks. Sir please Iska VBA Code Record Karta hun to error aata hai. How To solve this problem ?
@@ExcelMadeEasy444 VBA ki coding recording se nahi hoga. Likhna padega proper advance filter ka code.
@@Futureinhands Ok Will Try
Sir According to my question, Maine wo macro banaliya. dhanyawad sirji.
Sir please koi suggestion ho to comment kijiye.
'----------------
Option Explicit
Sub RearrangeOutput()
Dim DataSource As Worksheet
Dim Extracted As Worksheet
Dim Totaldata As Range
Dim Output As Range
Dim CriterialRange As Range
With Application
.ScreenUpdating = False
.DisplayAlerts = False
End With
'SET DATA SOURCE
Set DataSource = Sheets("DATA")
'SET OUTPUT SHEET
Set Extracted = Sheets("OUTPUT")
'SET DATA RANGE FOR EXTRACTION
Set Totaldata = DataSource.Range("A1").CurrentRegion
'SET OUTPUT REORDERED COLUMNS
Set Output = Extracted.Range("A10:D10")
'SET CRITERIA RANGE
Set CriterialRange = Extracted.Range("A1:A2")
Output.Resize(100000).Offset(1).Clear
Totaldata.AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=CriterialRange, CopyToRange:=Output, Unique:=False
'FORMATING OUTPUTS
With Output.CurrentRegion.Offset(1).Resize(Output.CurrentRegion.Rows.Count - 1)
.Borders.LineStyle = xlNone
.Interior.Color = xlNone
.Borders.LineStyle = xlContinuous
.Borders.Weight = xlThin
.Borders.Color = vbBlack
End With
Set DataSource = Nothing
Set Extracted = Nothing
Set Totaldata = Nothing
Set Output = Nothing
Set CriterialRange = Nothing
ActiveSheet.Columns.AutoFit
With Application
.ScreenUpdating = True
.DisplayAlerts = True
End With
End Sub