A fairly simple procedure that bypasses the need to create a Pivot Table is to use the built in filter.
Take a spreadsheet that tracks the number of hours for a task or tasks over a given period of time. In this case the period is one year.
The following screen shot shows the group of data after sorting by the last name:
- Once sorted, click in cell A1 to remove the A column highlight.
- Click on the Sort & Filter button on the Home ribbon.
- Click on the Filter option.
- A down arrow style button will appear beside each heading in row 1.
This is a simple way to quickly pull some relevant data from what can be a very complex spreadsheet.
Microsoft Small Business Specialists