How to Rank three columns together

[fadiu2]

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

 

[Fluff]

Cross posted How to Rank three columns together

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[fadiu2]

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

 

[Fluff]

However, since i am new user, it doesnt allow me to add any URL in my post.

That is not true, you can posts links right from day one.

the link you provided to a solution doesnt answer my question either

It's not meant to, if you followed the link you would see it's pointing to your thread on Excel Forum.

 

[fadiu2]

But I am totally unable to edit this post anymore or i seem to not find the edit option here.

 

[Fluff]

You don't need to edit the post, I have already supplied the link, we just ask that should you cross post in the future, you supply links.

 

[fadiu2]

Okay, I will keep in mind. Thank you

 

[Fluff]

Thanks

You are more likely to help with this, if you post some sample data to the board using the XL2BB add-in.
Otherwise potential helpers will have to recreate your data themselves.