This free Excel macro filters a data set to display the bottom 10 percent of the data set in Excel. This is a great macro for data analysis in Excel because it allows you to quickly and easily filter a large amount of data in Excel in order to view the most important data.
This macro is really easy to use and a great way to quickly filter your data. You only need to change the range in the macro to point to the first column of the table, data, or list which you would like to filter in Excel.
All of the elements below often appear within autofilter macros.
Range
Field
Criteria
Operator
Sub AutoFilter_Bottom_10_Percent()
Range("A1").AutoFilter Field:=1, Criteria1:="10", Operator:=xlBottom10Percent
End Sub