New Query

  • Thread starter Thread starter KiwiBrian
  • Start date Start date
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
 
Problem solved using a COUNTIF and then a SUMIF.
Thanks for being there anyway....
A wonderful supporting resource.

Brian Tozer
 
Back
Top