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:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi19WOUshGlebJk2tWPTDExj0iiDqR7E6M-J74YVU4SMd9XmW1SYqcA4hcYpoA7f3Y9unz9n75Bp2O8Z1TkHRPnXO2RfD64Tu2CYSx8aySqtqAE-ndfA1jZuuhyphenhyphenL-A2d5KgjBDSf0uLM1cP/s400/07-04-18+Office+Excel+2007+Sort+and+Print+-+Column+for+Sort.jpg)
- 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.
- Click on the relevant data column's down arrow to find available options.
- In this case we are looking for people whose total in the last column is at or below the value of 10.
- We choose "Less Than Or Equal To..."
- The Custom AutoFilter dialogue window comes up where we punch in 10.
- Click OK.
- Print the results.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVs6EDnBOraTZbJIDHjnG9l-CeOiAXBhmTgXqmN3KG4cpiGHbtiboO23BXQplCLp8EH0kVARQ1-QdGv2CST3L6EaKOEL-WWGpfyZpeTOazoFDU-VreOJlRcTeSxOtGlgje6AkfNh_zXztm/s400/07-04-18+Office+Excel+2007+Sort+and+Print+-+Filter+Number+Option+LTET+-+Results.jpg)
This is a simple way to quickly pull some relevant data from what can be a very complex spreadsheet.
Philip Elder
MPECS Inc.
Microsoft Small Business Specialists
No comments:
Post a Comment