+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Registered User
    Join Date
    06-27-2012
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2010
    Posts
    4

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

    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

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

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

    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

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

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

    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")
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  4. #4
    Registered User
    Join Date
    06-27-2012
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2010
    Posts
    4

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

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1