Hello,
I've been able to count unique values with criteria via multiple methods, but I can't find a way to make it work with dates. Please see attached.
Sheet 01-Jan should show a count of 17 unique values.
These 17 unique values should come from sheet Details_Date-Received column A when the date in column E matches the date in sheet Data's cell E2.
I've changed the dates to text strings that match, and this formula works:
=IFERROR(ROWS(UNIQUE(FILTER('Details_Date-Received'!A:A,'Details_Date-Received'!E:E=Data!E2))), 0)
However, if the cells are populated with dates, the formula results in a CALC error (displayed as 0 due to IFERROR function).
What am I doing wrong here?
Please help.
Thank you.
Bookmarks