When I use a function like MAX on an array of data, how do I get the cell reference of the result? Is there a way I can get that info using an excel function? For example: I want to know the date on which a maximum amount occurred in a table of dates and amounts. Is there a function that will get me the amount and the cell reference so I can find the corresponding date?