Count Unique Values With Multiple Conditions, Array Method

**5150** · 04-28-2014, 03:55 PM

Guys,

I need to modify the underneath Count Array Formula to count unique values based on multiple conditions. I can get the formulas to work with NUMERIC values in Column A in the N1 & N2 tabs. However, I cannot get the formula to work when column A contains TEXT values in the TX1 & TX2 tabs.

I've attached the XL file for your review of the project. I appreciate your help.

=SUM(IF(FREQUENCY(IF(('TX1'!$B$2:$B$15=B2)*('TX1'!$C$2:$C$15=C2)*('TX1'!$D$2:$D$15=D2),MATCH('TX1'!$A$2:$A$15,'TX1'!$A$2:$A$15,0)),MATCH('TX1'!$A$2:$A$15,'TX1'!$A$2:$A$15,0))>0,1))

**daddylonglegs** · 04-28-2014, 04:10 PM

I think that formula works OK, it isn't dependent on the values being numeric - 1 is the correct result for each of those criteria, isn't it? What results do you expect?

**popipipo** · 04-28-2014, 04:19 PM

Are you sure the results in sheet N2 are correct?
8-4-2014 has a result of 3
In sheet N1 there is only 1 row with 8-4-2014

**daddylonglegs** · 04-28-2014, 04:24 PM

Originally Posted by popipipo

.....8-4-2014 has a result of 3.....

Assuming the formula is correct then the date isn't part of the criteria - the formula counts the number of different dates (in column A) where the criteria in columns B, C and D are satisfied

**popipipo** · 04-28-2014, 04:37 PM

Maybe a pivot table is what you need?

Count Unique Values With Multiple Conditions, Array Method

LinkBack

Thread Tools

Rate This Thread

Display

Count Unique Values With Multiple Conditions, Array Method

Re: Count Unique Values With Multiple Conditions, Array Method

Re: Count Unique Values With Multiple Conditions, Array Method

Re: Count Unique Values With Multiple Conditions, Array Method

Re: Count Unique Values With Multiple Conditions, Array Method

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Count multiple conditions array only works with 1 value

[SOLVED] count the number of unique values given certain conditions

Count unique logs with multiple conditions of multiple sheets

Advanced unique cell count with multiple conditions ... help!

Count Unique text based on multiple conditions

Bookmarks

Bookmarks

Posting Permissions