Dear Excel Masters,
Data is from column A2 to O2 (green fill), on the other side is the calculations, T2 and U2 is a drop-down list menu which has months value from Jan to Dec which return the value from the data on the right side, how to get the MAX number for the selected months (in my example I selected May and July from the drop-down list so how to get the MAX of May, June, and July. This should be a dynamic change means the MAX change if the month change in the drop-down list.
Data is from column A2 to O2 (green fill), on the other side is the calculations, T2 and U2 is a drop-down list menu which has months value from Jan to Dec which return the value from the data on the right side, how to get the MAX number for the selected months (in my example I selected May and July from the drop-down list so how to get the MAX of May, June, and July. This should be a dynamic change means the MAX change if the month change in the drop-down list.