This free Excel macro filters data to display the bottom X percent of the data set in Excel. This is a great macro to use when you need to analyze subsets of data in Excel in order to better view the data.
This macro allows you to determine the percent of data which you would like to view from the bottom of the filtered list or data set. To change the percentage of the data you view, simply replace the "#" with the desired percentage. This number should be a whole number and not in decimal form.
All of the elements below often appear within autofilter macros.
Range
Field
Criteria
Operator
Sub AutoFilter_Bottom_X_Percent_Items()
'Replace the "#" sign with the bottom percentage of items you would like to have displayed
Range("A1").AutoFilter Field:=1, Criteria1:="#", Operator:=xlBottom10Percent
End Sub