Unique category with sum
Thanks Dave.
"Dave Peterson" wrote:
Or you could use the data|filter|advanced filter to extract the unique entries.
Then fill up the adjacent cells with formulas like:
=countif(sheet1!a:a,a2)
(Headers still in row 1)
recording a macro will get you very close.
choo wrote:
Hi,
I know how to use the advance filter to extract the unique category, but I
want to know how to calculate subtotal for each unique group and transfer all
these info to another worksheet, in code?
database:
apple,nz
apple,usa
orange,aus
apple,india
grape,aus
newsheet:
apple,3
orange,1
grape,1
Anyone?
--
Dave Peterson
|