well, from what I've read of your article, I think you could do all that - just select your data (header row included), go to Data --> Dynamic Array Report (sorry my Excel is in French so I'm not sure about the translations !) and create a dynamic array of your data on a new sheet. Then you can do whatever you want - sums, counts, etc. of all the rows you like, rearrange data, etc. It's really a very powerful, yet very simple tool and I don't understand why almost nobody uses it... :D
no subject
Date: 2009-08-14 02:33 pm (UTC)