I'm not familiar with array functions. I did use the pivot table and it worked, but I guess if would me more effective in my case ifyou show me how to write an array formula.