| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to count sets of repeating numbers
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count sets of cells in two columns? | Excel Worksheet Functions | |||
| I want random numbers generated without repeating numbers | Excel Worksheet Functions | |||
| How to count sets of numbers | Charts and Charting in Excel | |||
| How do I check repeating sets of number in a range | Excel Worksheet Functions | |||
| Need to display 4 sets of data on one x-axis with 4 repeating y a. | Charts and Charting in Excel | |||
Threaded Mode
