I am trying to find a formula where is will count the unique values of the
text column if it meets the criteria of the date and number column. I
actually have a few different criterias, but thought this may be easier to
explain.

Date Number Text
200811 1 Cat
200901 2 Dog
200901 1 Mouse
200811 2 Frog
200811 1 Cat
200901 2 Bird

This is the formula I used, it worked when I only had two if conditions and
then I added a third and now it is giving me an #VALUE

=SUM(--(FREQUENCY(IF((AND($A$2:$A$50=E$1,$F$2:$F$50=$B41, $J$2:$J$50=$B$5)),MATCH($L$2:$L$50,$L$2:$L$50,0)), ROW(INDIRECT("1:"&ROWS($L$2:$L$50))))0))

what do you want to do with this data?
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Lindsey" wrote:

I am trying to find a formula where is will count the unique values of the
text column if it meets the criteria of the date and number column. I
actually have a few different criterias, but thought this may be easier to
explain.

Date Number Text
200811 1 Cat
200901 2 Dog
200901 1 Mouse
200811 2 Frog
200811 1 Cat
200901 2 Bird

This is the formula I used, it worked when I only had two if conditions and
then I added a third and now it is giving me an #VALUE

=SUM(--(FREQUENCY(IF((AND($A$2:$A$50=E$1,$F$2:$F$50=$B41, $J$2:$J$50=$B$5)),MATCH($L$2:$L$50,$L$2:$L$50,0)), ROW(INDIRECT("1:"&ROWS($L$2:$L$50))))0))

I want to create a table where it will show me for each date and number how
many unique entries there are. Thanks

"Francis" wrote:

what do you want to do with this data?
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Lindsey" wrote:

I am trying to find a formula where is will count the unique values of the
text column if it meets the criteria of the date and number column. I
actually have a few different criterias, but thought this may be easier to
explain.

Date Number Text
200811 1 Cat
200901 2 Dog
200901 1 Mouse
200811 2 Frog
200811 1 Cat
200901 2 Bird

This is the formula I used, it worked when I only had two if conditions and
then I added a third and now it is giving me an #VALUE

=SUM(--(FREQUENCY(IF((AND($A$2:$A$50=E$1,$F$2:$F$50=$B41, $J$2:$J$50=$B$5)),MATCH($L$2:$L$50,$L$2:$L$50,0)), ROW(INDIRECT("1:"&ROWS($L$2:$L$50))))0))

Hello,

Take my UDF Pfreq:
http://www.sulprobil.com/html/listfreq.html

Regards,
Bernd