Excel Pro Tricks: Extract Top and Bottom N values using Excel Advanced Filter tool based on Formula

Learn how to use Excel Advanced Filter Tool based on formula to extract data based on criteria from the data range. This is one lesser known Excel Filter tool trick.
In this tutorial we will learn one of the rarest tricks using Excel Advanced Filter Tool. We do know that we can use Excel Filter tool to filter data based on criteria. However, very few know that we can use formulas as criteria range to filter or extract data from the data range in Excel.
Lets Excel!
Access or Download Practice workbook for this Excel tutorial:
1drv.ms/x/s!Apno7889bCyLl12Kw...
For more Excel tips, tricks and tutorials don't forget to subscribe to ‪@LearnExceltoexcel‬ YT channel.
Learn #Excel your way:
===================
Website: learnexceltoexcel.com/
--------------------------------------
Pick your favourite social page:
Fb: bit.ly/3yM3dvd
Tiktok: bit.ly/3wFllpf
Tw: bit.ly/3wGCRYU
Pin: bit.ly/3NsjKIU
Yt: bit.ly/3wxKL8a
Insta: bit.ly/3wtT9oW
Music by: / ikson
#excel #exceltips #exceltricks #exceltutorial #exceltutorialforbeginners #excelformula #excelfunctions #excelformulasandfunctions #excelformulatypes #exceltable #exceldata #data #dataentry #dataentryjobs #dataentryspecialist #datarestructure #datamodeling #datamodel #excelfilter #filter #advancedfilter #filtertool

[@gaelquinio7082]

You could use this to make it dynamic:
top 5
=TAKE(SORT($E$3:$F$26,2,-1),5)
bottom 5
=TAKE(SORT($E$3:$F$26,2,-1),-5)
that works on the latest version, not sure about the earlier ones

[@AA7860]

ur Every video is awesome... keep growing 💗!

[@natozeleo7579]

Vera level 😂❤❤

[@jianluo-kh9me]

vrer clever

[@LearnExceltoexcel]

Glad you liked it :)

[@krnrajan]

can you explain the criteria range and copy to list range. how it works. understood the formula. normally you mention the fields in the criteria range and condition under fields. Did not understand that part

[@debasischatterjee1328]

Pls make a video how to copy a data set single time but paste same data set multiple times in same sheet

[@farooqtahir538]

Conditional formating can high light this thing very easily

[@wanda1096]

Where is the description?

[@real5731]

What song it is?

[@AA7860]

background song?

[@johnx2686]

Can we use in 2007???

[@LearnExceltoexcel]

I think you can. I don't have access to 2007 version but advanced filter is available for some time now. Give it a try and let us know if you have 2007

[@johnx2686]

@@LearnExceltoexcel Thanks bro

[@debasischatterjee1328]

Pls make a video how to copy a data set single time but paste same data set multiple times in same sheet

[@debasischatterjee1328]

Pls make a video how to copy a data set single time but paste same data set multiple times in same sheet

[@aliheiba100]

Press Windows + v

[@debasischatterjee1328]

@@aliheiba100 windows + v not working

[@aliheiba100]

@@debasischatterjee1328 go to setting >system >clipboard and turn on clipboard after this Windows+V will be working