This free Excel macro filters a data set to show the bottom X number of items from that data set. This macro is really great because you can easily customize it to choose how many items you want to be displayed after you run the filter.
To determine the number of items to display simply replace the "#" sign in the macro with the number of items which you want to have displayed. Also, change the range reference to point to the first cell of the data which you would like to filter.
All of the elements below often appear within autofilter macros.
Range
Field
Criteria
Operator
Sub AutoFilter_Bottom_X_Number_Items()
'Replace the "#" sign with the bottom number of items you would like to have displayed
Range("A1").AutoFilter Field:=1, Criteria1:="#", Operator:=xlBottom10Items
End Sub