+ Reply to Thread
Results 1 to 8 of 8

to SORT the result based on HIghest Value

  1. #1
    Forum Contributor
    Join Date
    02-11-2015
    Location
    Jakarta, Indonesia
    MS-Off Ver
    2019
    Posts
    111

    to SORT the result based on HIghest Value

    Hello All,

    i would like to know what function will help for this request

    based on the picture below, yellow shades : the cells that i need a function to create report for Top 3 SKU in sales for each customer
    usually i am using pivot table to help me, but it takes 3-4 steps

    thank you
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Did13n; 09-16-2015 at 05:46 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: to SORT the result based on HIghest Value

    Please attach an EXCEL SHEET, not an image, as many of us can't see your image at all (and we can't edit it!!)
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor
    Join Date
    02-11-2015
    Location
    Jakarta, Indonesia
    MS-Off Ver
    2019
    Posts
    111

    Re: to SORT the result based on HIghest Value

    hi glenn,

    sorry ... i have added the excel file

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: to SORT the result based on HIghest Value

    Did not read requirement carefully!!
    Last edited by JohnTopley; 09-16-2015 at 09:03 AM.

  5. #5
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: to SORT the result based on HIghest Value

    see the attached file
    g4=LARGE(INDEX(SUMIFS($C$3:$C$14,$A$3:$A$14,$E$2,$B$3:$B$14,$B$3:$B$14)*(COUNTIF($F$3:$F3,$B$3:$B$14)=0),0),ROW(A1))
    Please Login or Register  to view this content.
    f4=INDEX(B$3:B$14,MATCH(G4,INDEX(SUMIFS($C$3:$C$14,$A$3:$A$14,$E$2,$B$3:$B$14,$B$3:$B$14)*(COUNTIF($F$3:$F3,$B$3:$B$14)=0),0),0))
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  6. #6
    Forum Contributor
    Join Date
    02-11-2015
    Location
    Jakarta, Indonesia
    MS-Off Ver
    2019
    Posts
    111

    Re: to SORT the result based on HIghest Value

    hi

    thanks a million @nflsales
    i've tried with combination of INDEX, MATCH and MAX , but all went wrong,
    now its all clearer ... once again thanks

  7. #7
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: to SORT the result based on HIghest Value

    Posted in Wrong Thread
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    02-11-2015
    Location
    Jakarta, Indonesia
    MS-Off Ver
    2019
    Posts
    111

    Re: to SORT the result based on HIghest Value

    haha ... no problem @nflsales, i had used your last function, and with little modification, all done properly

    but thanks anyway, really appreciate for your attention........
    a fool learn from experiences,wise from others

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto sort values from highest to lowest based off of value
    By qj67 in forum Excel Formulas & Functions
    Replies: 31
    Last Post: 06-24-2014, 10:24 AM
  2. sort entire row based on formula result in Column D
    By melody10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2013, 12:59 AM
  3. VLOOKUP to return highest result value
    By samcdavies in forum Excel General
    Replies: 1
    Last Post: 06-27-2012, 10:33 AM
  4. Replies: 3
    Last Post: 04-03-2012, 02:52 PM
  5. VBA code to find highest and 2nd highest number based in criteria
    By Michael007 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-25-2011, 08:38 AM
  6. Auto Sort Values From Highest To Lowest Based Off Of Value
    By CXP2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-03-2011, 09:15 PM
  7. Auto sort values from highest to lowest based off of value
    By Vbort44 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-09-2008, 07:21 PM
  8. Specifying the person who has achieved the highest result
    By Mary Ann in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-05-2005, 03:10 AM

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