+ Reply to Thread
Results 1 to 12 of 12

How to Rank three columns together

  1. #1
    Registered User
    Join Date
    07-28-2020
    Location
    Switzerland
    MS-Off Ver
    office 365
    Posts
    12

    How to Rank three columns together

    Hello Everyone, I am trying to rank these three columns based on the minimum values in all three simultaneously, using the formula shown in the picture. But somehow, it selects the values that arent minimum in one of the columns, as i highlighted in Yellow.
    How do i organize the formula so it wont give the rank this way. Ideally it should have ignore the 58 161 41 value.
    Thank you
    117130220_3768495486511004_2946102974861863894_o.jpg

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,231

    Re: How to Rank three columns together

    Hi fadiu,

    It seems you have 3 columns and a Rank column. Is your rank number which number column has the minimum value per row? I simply don't understand the problem. If you have only 3 columns how could a rank number be 5?
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    07-28-2020
    Location
    Switzerland
    MS-Off Ver
    office 365
    Posts
    12

    Re: How to Rank three columns together

    Hi Marvin,
    No, its in the entire column, if you look at the range selected in the formula shown. What I am trying to do is to count How many values are below the currently active cell value. and the formula checks not just one but three columns at the same time, so it counts for number of values below a certain value. i am attaching an image for the reference to what my end goal is Attachment 689397

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,644

    Re: How to Rank three columns together

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new, I'll provide the link for you this time: http://www.mrexcel.com/board/threads...ether.1141799/.)
    Last edited by AliGW; 08-02-2020 at 10:01 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  5. #5
    Registered User
    Join Date
    07-28-2020
    Location
    Switzerland
    MS-Off Ver
    office 365
    Posts
    12

    Re: How to Rank three columns together

    Thank you for the heads up, I wasnt aware of it.However, since i am new user, it doesnt allow me to add any URL in my post. and the link you provided to a solution doesnt answer my question either

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,644

    Re: How to Rank three columns together

    That is why I posted the link for you, as explained in my post. It's not a solution - it's a link to your post on the other forum. I don't have a solution for you - my post was a moderation notice.

    When you joined, you agreed to our rules, so perhaps ought to have read them then so that you were aware. Here's a link to the rules so that you can read them now: https://www.excelforum.com/forum-rul...rum-rules.html

  7. #7
    Registered User
    Join Date
    07-28-2020
    Location
    Switzerland
    MS-Off Ver
    office 365
    Posts
    12

    Re: How to Rank three columns together

    Thank you, I have read the rule now and tried editing my post to add the link to other forum but again I get the error of being not allowed to mention URL in my post.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,644

    Re: How to Rank three columns together

    Oh, dear! You aren't getting this.

    Please read the end of post #4 again:

    (Note: this requirement is not optional. As you are new, I'll provide the link for you this time: http://www.mrexcel.com/board/threads...ether.1141799/.)

  9. #9
    Registered User
    Join Date
    07-28-2020
    Location
    Switzerland
    MS-Off Ver
    office 365
    Posts
    12

    Re: How to Rank three columns together

    Thank you. Its clear now, sorry for the confusion.

  10. #10
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,438

    Re: How to Rank three columns together

    HOW TO ATTACH YOUR SAMPLE WORKBOOK:

    Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  11. #11
    Registered User
    Join Date
    07-28-2020
    Location
    Switzerland
    MS-Off Ver
    office 365
    Posts
    12

    Re: How to Rank three columns together

    I have attached sample of the worksheet here
    Attached Files Attached Files

  12. #12
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,438

    Re: How to Rank three columns together

    and some manually calculated results

+ 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. How to Rank with two columns
    By ShanPriya in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2020, 03:30 PM
  2. Replies: 4
    Last Post: 07-13-2017, 05:45 PM
  3. Replies: 6
    Last Post: 11-30-2013, 09:14 AM
  4. Replies: 1
    Last Post: 11-30-2013, 06:48 AM
  5. Rank 3 Columns, Rank Next 3 Columns, Rank Next 3...Etc.
    By kestefon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2013, 11:44 PM
  6. Replies: 1
    Last Post: 02-18-2012, 01:33 PM
  7. Rank 3 columns
    By neil40 in forum Excel General
    Replies: 5
    Last Post: 05-27-2011, 05:17 PM

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