276 reputation
29
bio website
location
age
visits member for 4 years, 4 months
seen May 8 at 19:16

Yes


Sep
24
awarded  Autobiographer
May
3
awarded  Caucus
Dec
14
awarded  Critic
Dec
12
comment How can I count unique values in one column based on criteria in two other columns?
maybe I do not understand your problem well enough but I don't have to. anyway, others can only give you an idea to the right direction. you have to adopt the ideas to your specific problem.
Dec
12
awarded  Commentator
Dec
12
comment How can I count unique values in one column based on criteria in two other columns?
press "F2" and after that press "Ctrl"+"Shift"+"Enter"
Dec
12
comment How can I count unique values in one column based on criteria in two other columns?
please read the most important words:
Dec
8
comment How can I count unique values in one column based on criteria in two other columns?
If you find a answer useful, please mark it as accepted answer. You help answerers to get reputation, and other questionaires to find their answer more quickly.
Dec
6
awarded  Supporter
Dec
6
awarded  Editor
Dec
6
revised How can I count unique values in one column based on criteria in two other columns?
added 54 characters in body
Dec
6
comment How can I count unique values in one column based on criteria in two other columns?
see extra answer below
Dec
6
answered How can I count unique values in one column based on criteria in two other columns?
Dec
6
comment How can I count unique values in one column based on criteria in two other columns?
the VBA-code below does exactly what you want. but if you want to have pure excel-functions, you must use array functions (F2 / Ctrl+Shift+Enter) SUM, IF, FREQUENCY, MATCH . . .
Dec
6
answered How can I count unique values in one column based on criteria in two other columns?
Dec
6
comment How can I count unique values in one column based on criteria in two other columns?
if VBA is OK then a "Collection"-object provides an easy possibility to count the number of unique entries
Dec
6
awarded  Peer Pressure
Oct
8
awarded  Yearling
Aug
8
awarded  Nice Answer
Aug
8
awarded  Enlightened