Excel Forum
Similar Content
Filter Data in Excel to Show Rows/Data That Meet Multiple Criteria for One Field - AutoFilter
Macro: This free Excel macro filters data in Excel based on multiple criteria for one field in th...
Filter Data in Excel - AutoFilter
Macro: This free Excel macro filters data in Excel using the autofilter feature in an Excel macro...
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
Macro: This free Excel macro illustrates all of the possible parameters and arguments that yo...



Excel Magic Trick #130: 3 Dimensional Database in Excel


See how to use the Table and List feature with data Validation to create a 3-dementional database (dynamic ranges) in Excel. Also see how to average with more than one criterion: AVERAGEIFS and DAVERAGE functions.





Got a Question? Ask it Here in the Forum.