Hi All,
In the attached workbook we have the range of values in A2:J168. In Col M, I have the dates. For each date, I need to find the MAX value in Col J for the rows that correspond to that date. For example, '10-01-06' has 24 rows of data from Row 2 through Row 25. I need to get the MAX value of the values in Col J.
I worked out a vba code which will do the job. But I am looking for a formula (maybe using INDEX, MATCH, AGGREGATE etc) that can be entered in Col N corresponding to the Date entries in Col M.
Please help.
Ashwin
In the attached workbook we have the range of values in A2:J168. In Col M, I have the dates. For each date, I need to find the MAX value in Col J for the rows that correspond to that date. For example, '10-01-06' has 24 rows of data from Row 2 through Row 25. I need to get the MAX value of the values in Col J.
I worked out a vba code which will do the job. But I am looking for a formula (maybe using INDEX, MATCH, AGGREGATE etc) that can be entered in Col N corresponding to the Date entries in Col M.
Please help.
Ashwin