MrDB4Excel
Active Member
- Joined
- Jan 29, 2004
- Messages
- 348
- Office Version
- 2013
- Platform
- Windows
Get Date From Column C Matching Row Of Max Value
I have an Excel spreadsheet where I save history of currency exchange rates.
In one cell I inserted the formula =MAX(A:A). This gets the maximum exchange rate appearing in that column.
In another cell I inserted the formula =CELL("address",INDEX(A:A,MATCH(MAX(A:A),A:A,0))).
I will name this result as $A&182, which is what this Excel sheet has indicated is the location of the maximum exchange rate.
This tells me what cell this maximum exchange rate is located.
I have another column that displays the date for which the indicated exchange rate was queried from the web.
Following is an example from this Excel sheet.
Column A Column B Column C
Exchange Rate Time Date
22.69832 21:11:11 Wednesday--24 Oct 2018
What I want to do is be able to get the date of the exchange rate that appears in the row 182 of this result $A$182 to appear in another cell close to the cell that reports $A$182.
Example of existing cells in my sheet as follows:
Maximum Value in Exchange Rate Column >>> 22.7114200 Location >>> $A$182
What I want is an additional cell to say:
Date of Maximum Exchange Rate Value >>>
Obviously somehow Excel would look in column C for the data that correlates with the same row of the maximum exchange rate value and return that find to the cell next to the cell that says: Maximum Value in Exchange Rate Column >>>
Thanks in advance for any good working resolution.
I have an Excel spreadsheet where I save history of currency exchange rates.
In one cell I inserted the formula =MAX(A:A). This gets the maximum exchange rate appearing in that column.
In another cell I inserted the formula =CELL("address",INDEX(A:A,MATCH(MAX(A:A),A:A,0))).
I will name this result as $A&182, which is what this Excel sheet has indicated is the location of the maximum exchange rate.
This tells me what cell this maximum exchange rate is located.
I have another column that displays the date for which the indicated exchange rate was queried from the web.
Following is an example from this Excel sheet.
Column A Column B Column C
Exchange Rate Time Date
22.69832 21:11:11 Wednesday--24 Oct 2018
What I want to do is be able to get the date of the exchange rate that appears in the row 182 of this result $A$182 to appear in another cell close to the cell that reports $A$182.
Example of existing cells in my sheet as follows:
Maximum Value in Exchange Rate Column >>> 22.7114200 Location >>> $A$182
What I want is an additional cell to say:
Date of Maximum Exchange Rate Value >>>
Obviously somehow Excel would look in column C for the data that correlates with the same row of the maximum exchange rate value and return that find to the cell next to the cell that says: Maximum Value in Exchange Rate Column >>>
Thanks in advance for any good working resolution.