Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Here is a brief example of what I am trying to accomplish:
A B 1 Don 2 Jim w 3 Don w 4 Bob 5 Jim w I would like to count the number of times that Don's name is on the list, then the number of times Don has a "w" in the next column. The COUNTIF function works for the first one but how do I get the second amount? The results should be: Bob 1 Don 2 1 Jim 2 2 I thank any and all in advance for any help that can be given on this. Deborah |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
type information in one column and second coloumn will know respo | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions |