Hi Howard,

Am Thu, 29 Sep 2016 11:27:33 -0700 (PDT) schrieb L. Howard:

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.

download "Bronze Silver Gold" from:
https://onedrive.live.com/redir?resi...=folder%2cxlsm


Regards
Claus B.
--
Windows10
Office 2016