# How to Rank three columns together

1. ## 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. ## Re: How to Rank three columns together

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?

3. ## 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. ## Re: How to Rank three columns together

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/.)

5. ## 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. ## 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. ## 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. ## Re: How to Rank three columns together

Oh, dear! You aren't getting this.

(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. ## Re: How to Rank three columns together

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

10. ## 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.

11. ## Re: How to Rank three columns together

I have attached sample of the worksheet here

12. ## Re: How to Rank three columns together

and some manually calculated results

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

#### 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