Spreadsheet: 824758d1680805553-count-number-of-unique-text-in-a-column-between-2-date-ranges-and-2-attributes-mockup-file
Sheet: Result Data

Select Date Range
August '22 | to | January '23 | <- Dropdowns
 |  |  |  | Place Name:
 |  |  |  | Place A | <- Dropdowns
 |  |  |  | Reporting Period:
 |  |  |  | Total # Unique Names (Column P Source Data) Between Date Range (Column A Source Data / A3 and [NAME] this tab) and at Place (Column S Source Data / E4 this tab) |  | <- Need Correct Formula to be able to toggle the dates (it works with the full date range but once I change the dates it doesn't work | <- Need Correct Formula to be able to toggle the dates (it works with the full date range but once I change the dates it doesn't work
 |  |  | 6 | # of Unique Names (Column P Source Data) Between Date Range (Column A Source Data / A3 and [NAME] this tab) and at Place (Column S Source Data / E4 this tab) with 2nd Attribute (Column L Source Data / Column D this tab) |  | <- Need Correct Formula to be able to toggle the dates (it works with the full date range but once I change the dates it doesn't work | <- Need Correct Formula to be able to toggle the dates (it works with the full date range but once I change the dates it doesn't work
 |  |  | 5 | # of Unique Names (Column P Source Data) Between Date Range (Column A Source Data / A3 and [NAME] this tab) and at Place (Column S Source Data / E4 this tab) with 2nd Attribute (Column L Source Data / Column D this tab) |  | <- Need Correct Formula to be able to toggle the dates (it works with the full date range but once I change the dates it doesn't work | <- Need Correct Formula to be able to toggle the dates (it works with the full date range but once I change the dates it doesn't work
 |  |  | 4 | # of Unique Names (Column P Source Data) Between Date Range (Column A Source Data / A3 and [NAME] this tab) and at Place (Column S Source Data / E4 this tab) with 2nd Attribute (Column L Source Data / Column D this tab) |  | <- Need Correct Formula to be able to toggle the dates (it works with the full date range but once I change the dates it doesn't work | <- Need Correct Formula to be able to toggle the dates (it works with the full date range but once I change the dates it doesn't work
 |  |  | 3 | # of Unique Names (Column P Source Data) Between Date Range (Column A Source Data / A3 and [NAME] this tab) and at Place (Column S Source Data / E4 this tab) with 2nd Attribute (Column L Source Data / Column D this tab) |  | <- Need Correct Formula to be able to toggle the dates (it works with the full date range but once I change the dates it doesn't work | <- Need Correct Formula to be able to toggle the dates (it works with the full date range but once I change the dates it doesn't work
 |  |  | 2 | # of Unique Names (Column P Source Data) Between Date Range (Column A Source Data / A3 and [NAME] this tab) and at Place (Column S Source Data / E4 this tab) with 2nd Attribute (Column L Source Data / Column D this tab) |  | <- Need Correct Formula to be able to toggle the dates (it works with the full date range but once I change the dates it doesn't work | <- Need Correct Formula to be able to toggle the dates (it works with the full date range but once I change the dates it doesn't work
 |  |  | 1 | # of Unique Names (Column P Source Data) Between Date Range (Column A Source Data / A3 and [NAME] this tab) and at Place (Column S Source Data / E4 this tab) with 2nd Attribute (Column L Source Data / Column D this tab) |  | <- Need Correct Formula to be able to toggle the dates (it works with the full date range but once I change the dates it doesn't work | <- Need Correct Formula to be able to toggle the dates (it works with the full date range but once I change the dates it doesn't work