Excel Forum
Similar Content
Calculate Percent Change in Excel
Tutorial: How to calculate the percentage amount that a value has changed in Excel. This includes q...
Goal Seek in Excel
Tutorial: Find a desired result by having Excel automatically change input values in Excel. Using ...
Quickly Replace A Lot of Data in Excel
Tutorial: The Find & Replace works much the same way as Find and is located in the same place. (...

Excel Magic Trick #236: Excel For Home Improvement

See how to create a database for keeping carpentry measurements, then see Advanced Filter Extract Unique Records and COUNTIF function formula for calculating how many lumber pieces you need to cut for your home improvement project.
Use Excel For Home Improvement Calculations
Custom Number Format (Double Quote, Space, Single Quote, Single Quote, Double Quote): 0.00 " '' "
Create a list to collect data and to automatically bring formatting down as you enter data
The SUBTOTAL function requires that you know the numbering for each function. The easy way to figure this out is to use the Function Arguments Dialog Box and then click on the blue Help link.
Advanced Filter (2003 Data menu, Filter, Advanced Filter; 2007 Data Ribbon, Sort & Filter, Advanced Filter) can extract Unique Records: 1) highlight data (be sure to include Field name/Header); 2) click "Copy to another location", click "Unique records only", select "Copy to" cell.
The COUNIF function will count the number of occurrences in a range of values.

Got a Question? Ask it Here in the Forum.