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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Function to return the cell reference of a function result
- Thread starter rundlem
- Start date
Similar threads
- Solved
