corresponding MAX value

Posted on 2007-03-26
Medium Priority
Last Modified: 2013-12-26
I have one sheet with two columns and some rows

          A                   B
1      Date         Production
2  01-Mar-07        123
3  02-Mar-07        200
4  03-Mar-07        101
6     The Max
7  02-Mar-07        200

I need to determine the MAX prodution in column B and the corresponding date from column A.  I know how to determine the MAX production, I don't know how to reference it back to column A.
Question by:bmiller250
LVL 14

Expert Comment

ID: 18797872
Hello bmiller250:

You could use the VLOOKUP function in Excel - it would require a reordering of the columns (or use of a dummy copy of Column A), but it should do the job.

LVL 81

Accepted Solution

zorvek (Kevin Jones) earned 1000 total points
ID: 18798007
In cell A7 put this formula:


In cell B7 put this formula:



Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question