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

Date |  |  |  |  |  |  |  |  |  |  | Attribute 2 |  |  |  | Name |  |  | Place
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | A |  |  | Place A
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | A |  |  | Place A
2023-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | A |  |  | Place A
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | A |  |  | Place A
2022-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | A |  |  | Place A
2022-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | A |  |  | Place A
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | B |  |  | Place A
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | B |  |  | Place A
2023-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | B |  |  | Place A
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | C |  |  | Place A
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | C |  |  | Place A
2023-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | C |  |  | Place A
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | C |  |  | Place A
2022-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | C |  |  | Place A
2022-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | C |  |  | Place A
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | C |  |  | Place A
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | C |  |  | Place A
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | D |  |  | Place A
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | D |  |  | Place A
2023-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | D |  |  | Place A
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | D |  |  | Place A
2022-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | D |  |  | Place A
2022-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | D |  |  | Place A
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | E |  |  | Place A
2022-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | E |  |  | Place A
2022-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | E |  |  | Place A
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | E |  |  | Place A
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | E |  |  | Place A
2023-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | E |  |  | Place A
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | F |  |  | Place A
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | F |  |  | Place A
2023-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | F |  |  | Place A
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | F |  |  | Place A
2022-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | F |  |  | Place A
2022-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | F |  |  | Place A
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | F |  |  | Place A
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | F |  |  | Place A
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | F |  |  | Place A
2023-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | G |  |  | Place A
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | H |  |  | Place A
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | H |  |  | Place A
2023-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | H |  |  | Place A
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | H |  |  | Place A
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | H |  |  | Place A
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | I |  |  | Place A
2023-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | I |  |  | Place A
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | J |  |  | Place A
2022-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | J |  |  | Place A
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | K |  |  | Place A
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | K |  |  | Place A
2023-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | K |  |  | Place A
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | K |  |  | Place A
2022-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | K |  |  | Place A
2022-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | K |  |  | Place A
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | L |  |  | Place A
2022-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | L |  |  | Place A
2022-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | L |  |  | Place A
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | L |  |  | Place A
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | L |  |  | Place A
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | L |  |  | Place A
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | L |  |  | Place A
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | L |  |  | Place A
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | L |  |  | Place A
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | M |  |  | Place A
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | M |  |  | Place A
2023-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | M |  |  | Place A
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | M |  |  | Place A
2022-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | M |  |  | Place A
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | N |  |  | Place B
2023-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | N |  |  | Place B
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | N |  |  | Place B
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | N |  |  | Place B
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | O |  |  | Place B
2023-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | O |  |  | Place B
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | O |  |  | Place B
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | O |  |  | Place B
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | O |  |  | Place B
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | O |  |  | Place B
2023-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | P |  |  | Place B
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | P |  |  | Place B
2023-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | P |  |  | Place B
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | P |  |  | Place B
2022-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | P |  |  | Place B
2022-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | P |  |  | Place B
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | P |  |  | Place B
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | P |  |  | Place B
2023-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | P |  |  | Place B
2023-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | Q |  |  | Place B
2022-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | Q |  |  | Place B
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | Q |  |  | Place B
2023-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | Q |  |  | Place B
2022-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | Q |  |  | Place B
2022-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | Q |  |  | Place B
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | Q |  |  | Place B
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | R |  |  | Place B
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | R |  |  | Place B
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | R |  |  | Place B
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | R |  |  | Place B
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | R |  |  | Place B
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | R |  |  | Place B
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | R |  |  | Place B
2022-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | R |  |  | Place B