Tranferring from a list to a two parameter table

**f0r3st** · 05-12-2009, 10:58 PM

Btw, I hope that it will be a formula and not use pivot table as there are various other tables in the sheet as well and I want to standardize how the tables appear

**DonkeyOte** · 05-13-2009, 05:55 AM

IMHO you need to re-think your approach... trying to populate the matrix on another sheet away from the list will require copious amounts of SUMPRODUCT formulae which will lead to v poor performance... I would propose you create the same matrix adjacent to the list and then run standard SUMIF from your summation sheet -- see attached -- this will be far more efficient.

**f0r3st** · 05-13-2009, 09:16 PM

great, but I would require another table that shows all the activity of the personnel in 1 line, from the example that you sent me, I would require john's activites to be summarized in 1 line rather than 2. In the real list that I'm using, most people will go overseas more than once, so i will need all the data of everyone to be in a single row. Is that possible?