Used Pivot Table, VBA and
Excel 2003 Lists. No formulas used.
Data can be located anywhere,
can have odd rows and columns,
be in random order and incomplete.
Dynamic data ranges provided for easy editing.
http://www.freefilehosting.net/download/3d94b