How to find the cooresponding value of a Max Value

[johnsoncj2002]

If Column A5:A60 is a date (example A5 = 01-01-2012 and so on) and column C5:C60 has a number.

I can use the Max function to find the highest number in C5 through C60 but how can I find the corresponding date in Column A?


Thanks.

[ConneXionLost]

How about:

Please Login or Register  to view this content.

Format the result as a date.

Cheers,

[johnsoncj2002]

That didn't work. That date in column A didn't match my max value in column C.

[ConneXionLost]

Can you attach a sample file?

To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'.
To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

On this page, below the message box, you will find a button labelled 'Manage Attachments'.
Clicking this button will open a new window for uploading attachments.

You can upload an attachment either from your computer or from another URL by using the appropriate box on this page.
Alternatively you can click the Attachment Icon to open this page.

To upload a file from your computer, click the 'Browse' button and locate the file.

To upload a file from another URL, enter the full URL for the file in the second box on this page.
Once you have completed one of the boxes, click 'Upload'.

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[johnsoncj2002]

see attached

[ConneXionLost]

The range in your spreadsheet is C5:C260, the range you identified in your first post is C5:C60.

Change the ranges in the formula.

[johnsoncj2002]

You're right! Is there a way for this to work by selecing the entire column range instead of specifing the row's. I tried
=INDEX(Forecast!A:A,MATCH(MAX(Forecast!CZ:CZ),Forecast!CZ:CZ,0))

But it didn't work.

[ConneXionLost]

Okay, I renamed your Sheet1 as "Forecast", and moved your column C out to column CZ, and used this formula (from Sheet2):

Please Login or Register  to view this content.

It works just fine.

[johnsoncj2002]

That worked.....I wish you could solve this one for me
http://www.excelforum.com/excel-gene...ine-model.html