Posted to microsoft.public.excel.worksheet.functions
|
|
Array Formula to return Header
On Thursday, September 29, 2016 at 12:01:48 PM UTC-7, Claus Busch wrote:
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.
--
Wow, very nice indeed!!
Never cease to amaze.
Thanks, Claus.
Howard
|