Hi There,
It may be easier to view the attachment to see what I am trying to do.
I would like to split frequency data by groups.
So I have 2 different names in column A, with a bunch of their ratings in column C.
I would like to be able to view the frequency of their individual ratings to see who gave the most types of ratings.
Many Thanks,
Matt
In D23 Cell
=COUNTIF($C$2:$C$20,C23)
In G23 Cell
=COUNTIFS($A$2:$A$20,"Sam",$C$2:$C$20,F23)
In J23 Cell
=COUNTIFS($A$2:$A$20,"Pete",$C$2:$C$20,F23)
Drag all the formula's down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
For Pete, in column G, use the formula :For Sam, in column J, use the formula :Formula:
Please Login or Register to view this content.You can either manually input the names or can choose from another column. If it is the latter case you want, i.e. if the names are placed in a column and you want to have the count for ratings for each name, then this needs to converted to an array formula.Formula:Please Login or Register to view this content.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
Thank you both very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks