Dates of visits from table based on the crtieria
Hello, I have 100 villages on a table, and there is a target of visiting various villages in a month. I have used COUNTIF formula to put on the number of times a village is visited in one month. How to find out dates of each visit for one village. Like Village A is visited twice in May, 5th and 10th of the month. Countif brings 2 for Village A from May, but what formula to use to pull out dates of 5 and 10 may.
Hello, I have 100 villages on a table, and there is a target of visiting various villages in a month. I have used COUNTIF formula to put on the number of times a village is visited in one month. How to find out dates of each visit for one village. Like Village A is visited twice in May, 5th and 10th of the month. Countif brings 2 for Village A from May, but what formula to use to pull out dates of 5 and 10 may. Read More