Required - Excel Formula To Link Max Sales With 'Gold'.

[James Perry]

I'm in sheet1.
Col A1 has the label Senior_Sales_Manager.
A2 thru A6 contain the names of 6 unique senior sales managers.
Col B1 has the label Jan_Sales.
Col C1 has the label Gold.
Col D1 has the label Feb_Sales.
Col E1 has the label Gold.
Col F1 has the label March_Sales.
Col G1 has the label Gold.
And so forth…..till…..Dec_Sales.
My Q -
If senior sales manager AAA has the max sales by value in Jan, then Gold1 must appear in the Gold column after Jan_Sales column and in the same row as AAA.
If senior sales manager AAA tops the sales again in Feb, then Gold2 must appear in the Gold column after Feb_Sales column and in the same row as AAA.
If senior sales manager DDD has the max sales by value in Mar, then Gold1 must appear in the Gold column after Mar_Sales column and in the same row as DDD.
Required -
An Excel formula for 12 months (Jan_Sales thru Dec_Sales) to give the desired results.
Thank you very much.

 

[Somendra Misra]

Hi James,

See the attached file. Press F9 to see various results.

Regards,

 

[Oxidised]

Hi James,
Please see attached file to confirm if it answers your query. The formula used in cell C2 to identify if a "Gold" condition is required is below, and copied into every column with heading "Gold"
=IF(B2=MAX(B$2:B$7),"Gold"&COUNTIF($A2:A2,"gold*")+1,"")

 

[James Perry]

Thank u guys and bless ya.
Those 2 solutions r awesome!!
Also thank u guys for the examples in Excel.

 

[Oxidised]

your welcome