On Thursday, September 29, 2016 at 1:33:02 AM UTC-7, Claus Busch wrote:
Hi Howard,

Am Thu, 29 Sep 2016 00:32:29 -0700 (PDT) schrieb L. Howard:

I am thinking there does not need to be a 'range', like 499 and < 1500 etc.

So I am using =IFERROR(INDEX($E$1:$P$1,MATCH(MAX(IF($E$2:$P$2=50 0,$E$2:$P$2)),$E$2:$P$2,0)),"") pulled across B, C & D.

B for 500, C for 1500 & C for 5000. And this looks like it meet requirements.

I don't know what you want to do.
Can you send me an example workbook with the expected output?


Regards
Claus B.


Hi Claus,

The formula works fine but the explanation given about the data was misleading.

Here is a worksheet with some expected examples shown in the Bronze, Silver and Gold columns A, B, C.

https://www.dropbox.com/s/tknhdsiq1e...Gold.xlsm?dl=0

Mo gets bronze date of April with 500 accumulated by that month.
Syed gets bronze, silver, gold all on same month of September.

So it is the month they hit 500 returns the header to bronze column A.
The month they hit 1500 returns the header to silver column B.
And the month they hit 5000 returns the header to gold column C.

I am wondering if this will require VB code instead of formula. I am working on code as I don't know where to start with a formula.

Howard