To find

If you need to find text that shares some characters but not others, use a wildcard character.

Use
To find
? (question mark)
Any single character
For example,sm?th finds "smith" and "Smyth"
* (asterisk)
Any number of characters
For example,*east finds "Northeast" and "Southeast"

Filter for top or bottom numbers
1. Select a range of cells containing numeric data.
2. On the Home tab, in the Editing group, click Sort & Filter, and then click Filter.

Click the arrow in the column header.
Point to Number Filters and then select Top 10.
In the Top 10 AutoFilter dialog box, do the following.
0. In the box on the left, click Top or Bottom.
1. In the box in the middle, enter a number.
2. In the box on the right, do one of the following:
§ To filter by number, click Items.
§ To Filter by percentage, click Percent.
Sub total
You can automatically calculate subtotals and grand total in a list for a column by using the Subtotal command in the Outline group on the Data tab.