OP says he is interested in a pivot table/Powerpivot solution: http://www.excelforum.com/excel-form...ml#post4213491 I don't know pivot tables, but suspect that it will be a very effective approach for what he/sheis doing.