I have a spreadsheet with different categories: the first category has options A,B & C and the second category has options 1,2 & 3. What I need excel to do is count the number of items falling under each possible combination of data. I need to know how many times do the combinations A1,A2,A3,B1...etc. appear. The data set I am working with will continue to grow and the number of times each combination appears is important for other calculations in the sheet. Any help would be appreciated!!
Last edited by ransome; 05-17-2010 at 08:39 PM.
To get the combo in D3, enter =B3&C3 and copy down
To get a count in next column, in E3, enter: =COUNTIF(D:D,D3) and copy down.
If you want you can set up a table of unique combinations, and use the countif against that table, referencing column D and the table would be the criteria.
Or you can use a pivot table to summarize the counts.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Awesome that worked perfectly. Thanks a lot!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks