Hi Gurus,
I have a dataset that has a location with dates and percentages and i need a formula that would do a vlookup on the location and count the dates and return the result of the percentage based on a range of dates selected. So if I select a date range say from Jan 1st 2017 to Mar 31st 2017, the formula would count the number of dates occurring for that location and return an average of the Diff %.
Hope I am making sense.
I am attaching the data set so that you can get an idea of what I am talking about. If you require further information, please let me know as I might not have been as clear as I should be.
Thanks.
Bookmarks