Main Profile

At A Glance

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.
Length: 07:55

Contact

Questions about Excel Magic Trick #130: 3 Dimensional Database in Excel

Want more info about Excel Magic Trick #130: 3 Dimensional Database in Excel? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question