Finding first largest value for each group

[alexkurt]

I can have a set of independent products with independent quantities.
In Column D, I need to apply Formula-1 ONLY for the FIRST maximum quantity in Column B, for EACH product set in Column A, and Formula 2 to any other quantities within each product.
Thank you for help.

 

[Fluff]

How about

="FORMULA "&IF(COUNTIFS(A$2:A2,A2,B$2:B2,MAXIFS(B:B,A:A,A2))=1,1,2)

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Finding first largest value for each group
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[alexkurt]

How about

="FORMULA "&IF(COUNTIFS(A$2:A2,A2,B$2:B2,MAXIFS(B:B,A:A,A2))=1,1,2)

Close but doesn't work

How about

="FORMULA "&IF(COUNTIFS(A$2:A2,A2,B$2:B2,MAXIFS(B:B,A:A,A2))=1,1,2)

 

[alexkurt]

solved here:
Finding first largest value for each group [SOLVED]
Thank you for help!

 

[Fluff]

You're welcome & thanks for the feedback.