Using index and match to return a value based on earliest occurrence (MONTH)

Hello all,

I have an issue in Excel and I am at a loss with how to solve it...hopefully, someone can help

I currently have a table that has values and dates in months.

I need a formula to return the earliest month that a value occurred in (if multiple times).

Name	Highest (Month)	Month
Bill	16	Aug
Matt	356	Jul
Bob	356	Jun
John	67	Sep

Book1.xlsx

I have this formula at the moment, which returns the month of the largest amount BUT it does the first month in the table, not the first month in the year that it occurred.

=INDEX(Table3[Month],MATCH(MAX(Table3[Highest (Month)]),Table3[Highest (Month)],0))

So, I get the result of Jul, whereas I need it to be Jun.

I can't put the table in order because it changes dependent on other stuff, the only thing that doesn't change is the names.

I hope that makes some sense and eagerly await some help.

Thanks

If you post a workbook with some sample data it will be much easier to help you.

This is an array formula, it has to be entered with Ctrl + Shift + Enter.

Formula:

Please Login or Register  to view this content.

''''''''''''''''

Thanks - if I change it so that there is a value it seems to work OK.

However, if there are two with the same value, I want it to return the earliest occurence based on the date.

So D23 should be the earliest date.

Earliest month match.xlsx

Ignore this - I was being dense!!!

Thanks