George Simms provides a good example of using FREQUENCY
to count unique criteria with conditions. See:
http://tinyurl.com/6fwny
HTH
Jason
Atlanta, GA
-----Original Message-----
Hello everybody,
I've found recently a very useful formula on Chip
Pearson's page
(http://cpearson.com/excel/duplicat.htm) dealing
with "counting unique
entries in a range". I think the best one for my special
case would be the
one for "no text / no string" values, i.e.
=SUM(N(FREQUENCY(Range, Range)0))
From this point, I'm trying to elaborate a bit on this
by adding two
conditions in order to get something like:
"Count unique entries in a specific (f. ex. A) column,
but only if in column
B we have a value = 555 (number) and in column C we have
a value = XYZ
(text)."
I would like to avoid "filter, copy and paste"
solution...
Till this point, I was unable to find a correct solution
by myself. At one
point I've thought about passing through SUMPRODUCT, but
with no success.
Maybe one of you have already had such a problem? Do you
see how to resolve
this?
Thanks a lot for any comment or hint!
Mark
.