Do you need a little more flexibility than the autofilter? Create your first advanced filter.
1. Add your filter column and criteria information somehwere in your worksheet
2. Select the entire range and headings you would like to filter
3. On the main menu click Data then Filter then Advanced filter
4. Click in the Criteria range box, then on your worksheet select the filter column and criteria as a range
SideNote: List range should already have values in it, if not, select your range and headings again
5. Click OK and see your newly advance filtered data (in this example it only shows Amounts greater than 500$ now
