Find the location of data which contains maximum value.

Find the ROW number of maximum value :-

To find the ROW number of data which contains maximum value.

For example See below printshot.

The following array formula returns the row number of the maximum value.
{=MIN(IF(data=MAX(data),ROW(data),""))}

In case , if we need to find the cell address of the maximum value in the data range. Then, add  ADDRESS function to above formula where ROW number that are found is the first argument of it , another argument required is COLUMN number.

The following array formula returns the cell address of the maximum value.

{=ADDRESS(MIN(IF(data=MAX(data),ROW(data),"")),COLUMN(data))}