 |
 |
| About MrExcel |
| Consulting Services |
| Learn Excel Resources |
| Challenge of the Month |
| MrExcel Seminars |
| MrExcel Store |
| Podcast |
| Search |
| Media |
| Contact |
| Home |
 |
Excel 2007 provides dramatic improvements to the Filter function in Excel. You can quickly filter a list to find a specific customer, records from a certain month, or records highlighted in a certain color.
Try these steps to add an ad-hoc total to your data set:
- Turn on the filter feature as described above.
- Filter the list to one customer: Open the Customer dropdown. Click Select All to unselect all customers. Click on customer to select that customer.
- Select cells directly below the data in the columns for any numeric fields.
- On the Formulas tab of the ribbon, select the AutoSum icon (it is a Greek letter E, or Sigma)
Choose a different customer from the dropdown in D1 and the total will reflect that customer:
New in Excel 2007- The dropdown for a date column automatically offers a hierarchical view of the dates. Click the plus sign
next to 2007 to see all of the months in 2007. Click the plus sign next to any month to see all of the days in that month.
Or, use the new Date Filters to filter to last week, this month, next quarter, and so on.
- Filter a text field to only records that contain a certain word
- Filter a numeric column to only records above average:
- Filter by color:
Check back after March 19, 2008 and you can view my segment here.
I really hope to give away 5 million copies of the book, so please send your co-workers and friends to
leobook.html.
MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.