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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting query 1
Count entries in list 2
VBA: How can I use a string variable as autofilter criteria? 4
I need ONLY subtotals copied to a second sheet 4
Pointer please 3
Query 3
Excel Transpose Cells in Excel 4
SUM - IF - AND 7

Back
Top