Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to count unique occurances of names in column a which satisfy
conditions in two other columns. For instance: A B C Smith faculty annual fund Smith faculty annual fund Jones faculty annual fund Smith faculty new gift Jones faculty new gift The number of unique occurances of Smith in column A where column B=faculty and column C=annual fund. The answer of course is 2, but how do I write a formula to answer that question in a long list of data? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A conditional Sum & Count | Excel Worksheet Functions | |||
conditional count | Excel Worksheet Functions | |||
Please help me with a Conditional Count... | Excel Discussion (Misc queries) | |||
Conditional Count | Excel Worksheet Functions | |||
conditional count | Excel Worksheet Functions |