I have a data set of monthly data for nine different districts. What I am looking to do is find a district's value for a particular month than find the max value for the 36 cells above. But I need the formula to be dynamic so when I select a different district it looks up the correct month value then again finds the max for the 36 cells above.
In an effort to make it the lookup easier, I concatenate the districts and months together (District1January, District1February..., District2January,District2February...,etc.) but i don't know what formulas to nest together to have the formula move when i select a new district.
Bookmarks