Hi, appreciate if you can help...
I have a range with dates, which also contains some duplicates and blank cells. To find the # of unique entries in this range I'm using the following formula (example):
=SUMPRODUCT((J2:J10<>"")/COUNTIF(J2:J10,J2:J10&""))
This works. However.
How do I find the # of unique entries (or, to be more specific, unique dates) in column J if the output should also be matching one more criteria? Let's say, all unique entries in column J must also have a matching entry "001" in column K, while column K would be filled with random entries 001, 002, 003, 004 etc.
I have a range with dates, which also contains some duplicates and blank cells. To find the # of unique entries in this range I'm using the following formula (example):
=SUMPRODUCT((J2:J10<>"")/COUNTIF(J2:J10,J2:J10&""))
This works. However.
How do I find the # of unique entries (or, to be more specific, unique dates) in column J if the output should also be matching one more criteria? Let's say, all unique entries in column J must also have a matching entry "001" in column K, while column K would be filled with random entries 001, 002, 003, 004 etc.