Excel sheet is subtitled but need now to do a count of the items in each grouping so need to find subtilted rows by using a macro and count the number of items in each grouped section (column a) placing the count value in the relevant subtitled row in Column A. no idea where to start can anyone help. Running the subtilteld function again adds another row but i need all of this on the same row..
A:
You could just add a column with the value 1 in each cell and setup sub-totals
baldy
2009-12-10 12:28:58
lateral thinking - i like it...thanks
total newbie
2009-12-10 12:40:20
Then accept the answer :-) Unless you are set on doing this with a macro
baldy
2009-12-10 12:44:11
A:
Pivot tables are set up to do this natively. No programming needed.
guitarthrower
2009-12-10 17:10:37