Excel-User-RR wrote:
Please lend expertise to the following dilemma: In the list below column A
contains repeating session numbers. Column B contains the session date.
Column C contains the person's name. How can I count the number of sessions
with people attending in specific amounts? For example I would like to know
how many sessions were attended by 2 people, by 3 people, by 4 people, etc.
Each result would be in a separate cell. Thanks for your time and assistance
with this Excel 2003 formula. Per the example the results should be: 2
people=1 session (#2), 3 people=2 sessions (#s 1 & 3).
A B C
1 2/13/09 Mike Jones
1 2/13/09 Sue Day
1 2/13/09 Joe Blow
2 2/20/09 Wes East
2 2/20/09 Lars Lyes
3 2/22/09 Val Zunn
3 3/2/09 Xara Qu
3 3/2/09 Kyle Miles


One way would be to add the following in D2:D9 (assuming the data above is in
A2:C9 with headers in row 1):

=IF(COUNTIF($A$2:A2,A2)=1,COUNTIF($A$2:$A$9,A2),"" )

Put "Attendees" in D1. Then you could create a PivotTable with "Attendees" in
the row field (un-check blanks) and Count of "Session Number" in data items.