Dear all,
I am trying to create a formula that answers to the follow:
- unique numbers in ID and CITY if "answer for ACTIVITY 1" OR "answer for ACTIVITY 2"
How can i make a formula to achieve this conclusion?
| ID (person) | CITY | ACTIVITY ONE | ACTIVITY TWO |
| 12345 | A | number1 | |
| 12345 | A | number2 | |
| 12345 | A | | done |
| 12345 | A | number1 | |
| 12345 | A | | done |
| 12345 | A | number1 | |
| 67890 | B | number1 | |
| 67890 | B | | done |
| 67890 | C | number2 | |
Thank you in advance!
Carla
