New Query

K

KiwiBrian

I have a list of 100 items in Column A containing many duplicates.
In Column B I have category numbers, 1 to 9, thus effectively grouping the
items into 9 categories.
I wish to create a new 9 by 2 table/list that lists the total number of
items in each category.
What is the preferred way of doing this?

Thanks
Brian Tozer
 
K

KiwiBrian

Problem solved using a COUNTIF and then a SUMIF.
Thanks for being there anyway....
A wonderful supporting resource.

Brian Tozer
 
Top