Finding highest number based on three columns with duplicate info in rows

[vecnaa]

Hi Everyone,

New to this form hoping someone can help me out . I need a formula in a new Column D to analyze the information below and return "Yes" if the number in Column C is the highest for the product (Column B) within each particular store (Column A). I need it to return "No" if it is not. So basically for each product there will definitely be a YES in the store in the row with the highest number in Column C (does not matter if its not the highest number overall for that type of product across all stores). Here is an example of the information I am working with:

The expected outcome is listed in Column D. Thanks in advance for your help! Please let me know if any additional information is needed.

Column A	Column B	Column C	Column D (does not exist yet)
Store A	Pizza	990	YES
Store A	Pizza	11	NO
Store B	Pizza	222	NO
Store B	Pizza	910	YES
Store B	Soda	890	YES
Store A	Soda	121	NO
Store A	Soda	810	YES
Store C	Pizza	900	YES
Store C	Pizza	84	NO
Store C	Soda	232	NO
Store C	Soda	800	YES
Store A	Envelopes	710	YES
Store A	Envelopes	57	NO
Store B	Soad	43	NO
Store B	Envelopes	790	YES
Store B	Envelopes	33	NO
Store C	Envelopes	700	YES
Store C	Envelopes	12	NO

[benishiryo]

hi vecnaa, welcome to the forum. copy this formula & paste into the formula bar in D1:

Please Login or Register  to view this content.

instead of hitting enter, press CTRL + SHIFT + ENTER

[Haseeb Avarakkan]

Hi Vecnaa,

Assuming data starts from A2 to down.

Try this in D2 with just ENTER, then copy down.

=IF(COUNTIFS(A:A,A2,B:B,B2,C:C,">"&C2),"No","Yes")

[vecnaa]

Thanks to you both! Both solutions worked out wonderfully. I really appreciate all of your help !