Finding unique values for a date range

I need to find unique users from a particular location that appear between two dates.

I can find all entries (in column P of the My Marketing sheet) within the date range (defined by E53 and F53) and within a particular country with:
=IFERROR(COUNTIFS('My Marketing'!P:P,">="&E53,'My Marketing'!P:P,"<"&F53,'My Marketing'!E:E,"Australia"),0)

And I can find all unique entries in the column D with:
=SUMPRODUCT(('My Marketing'!D:D<>"")/COUNTIF('My Marketing'!D:D,'My Marketing'!D:D&""))

But no amount of experimenting or googling has lead me to the solution that allows me to join these together.

How do I adjust the first function to limit the results to unique ones?

Thanks for you help.
Gav

Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Here's an example.

G2/3 and H2/3 are where I need to exclude duplicates from the results.

Hi. One question. When you say start date and end date; do you mean INCLUDING both dates? see attached, where I have assumed that you meant INCLUDING both dates

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

How's this...

From memory, the real problem was that I hadn't made some of the row references absolute in V1. Sorry!!

Anyhow, I'm glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.