I have a spreadsheet that contains a date in column A and a number value in column C.
I have a formula that tells me the highest and lowest values in column C. What I would like is to have another formula that tells me the value in A that is on the same row as the highest and lowest values in C.
So if this is my sheet, the date is Column A; the value is column C:
One formula that I already have in place tells me that 46 is the highest value of those four lines. It displays that in cell in another part of the sheet. I even found a formula that tells me what row that is (though I'm not sure that's helpful in my case).
I would like to place a formula in another cell that tells me the value of A1 (Jan-2014) based on C1 being the highest value in C. If things change and C4 ends up being a higher number, it should automatically switch to the value of A4 (Apr-2014).
I'm not sure I'm making a lot of sense here; I hope I'm being clear. Please ask questions if clarification is needed.