# Count Unique Values With Multiple Conditions, Array Method

1. ## Count Unique Values With Multiple Conditions, Array Method

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))

2. ## Re: Count Unique Values With Multiple Conditions, Array Method

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?

3. ## Re: Count Unique Values With Multiple Conditions, Array Method

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

4. ## Re: Count Unique Values With Multiple Conditions, Array Method

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

5. ## Re: Count Unique Values With Multiple Conditions, Array Method

Maybe a pivot table is what you need?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1