Results 1 to 3 of 3

Thread: Ranking formula with a subset with a column

  1. #1

    Ranking formula with a subset with a column



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am trying to rank a column of data within a subset of the dat. I have attached a sample sheet but here is what I want to do

    Column A is a Sku number, Column B is a total $ amount for the sku and Column C is a color

    I want to add a formula to rank the dollar amounts based on the color

    Any ideas are appreciated
    Attached Files Attached Files

  2. #2
    Acolyte Azumi's Avatar
    Join Date
    Jan 2014
    Location
    Indonesia
    Posts
    30
    Articles
    0
    Excel Version
    2010
    hope this help, something trouble i can't upload the file at this forum so i upload it somewhere

    https://simpan.ugm.ac.id/s/RnypgCisUki1lR1

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,548
    Articles
    0
    Excel Version
    365
    In D2:
    =1+SUMPRODUCT(($C$2:$C$83=C2)*($B$2:$B$83>B2))
    and copy down.
    (also in attached)
    Attached Files Attached Files
    Last edited by p45cal; 2017-01-20 at 12:49 AM.

Posting Permissions

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