Hi - I'm an Excel dummy so my apologies if there's an obvious way to do this....
What I need to do is count the occurrences of each distinct item within a range, without having to specify what those items are.
In other words, instead of telling Excel "count how many Sue's, James's and Chris's there are between X and Y", I need to tell it "display a summary showing each distinct item in that range and how many of each there are".
Is this possible with a formula, or will I need some VBA code to do it?
Hi,
Try the following:
- Sort your data by item.
- Insert a column heading in the first row.
- Select the whole column where your items are (or just the required range).
- In the data menu click subtotals.
- Excel will do the subtotals by item and since your data is all alpha it will use count function for the subtotals.
Welcome to: http://www.exceldigest.com/myblog/
"Excel help for the rest of us"
Hi, and welcome to the forum.
Your request is a little ambiguous since the items you want to count will have to be specified in some way or another. Excel is good but not psychic
se1429 has suggested one option. The other is to extract a unique list of items with the Data Filter Advanced Filter Unique functionality, and then use a COUNTIF() function to count the items in the required range using the unique list values as the second element in the COUNTIF() function.
HTH
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks