Using the enclosed file as a referece what formula can I use to count the unique entries based on "TWO" arrays (Column A + B). D1, counts only unique entries for one array - Column B. Since the total unique entries is 8 for Column B, how many unique entries are for "open", "closed', "new"? Column F has the correct manual answers for unique entry based on Column A & B. What formula can I use to count two unique array entries? Thx.
Bookmarks