• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula to rank with condition

Jet Fusion

New Member
Hi all

Can someone please help with a formula, I've managed to use a formula to rank the entries from lowest to highest but i need it to also rank on a condition.

The condition is only values are ranked when the two columns have a yes. See attached.

Also i need for the lowest value and company name then to be copied to the above cells see attached.

Thank you in advance.
 

Attachments

Jet Fusion

New Member
Hi

Thanks, not sure if i'm doing something wrong but it seems all works well untill i input the formula for the lowest value with the company name.

See attached original file.

Thanks
 

Attachments

Jet Fusion

New Member
Sorry for the bother but if you check the file that you modified it's not updating, If you change all the columns with Y & N it doesnt update the value
with the lowest
 

Nebu

Excel Ninja
Hi:

Not sure what you meant. Its working fine as per the logic you had given me or am I missing something?

Thanks
 

Nebu

Excel Ninja
Hi:

I am not sure, when I opened the file it is showing price for "E" in F2 and Company Name "E" in F1 which is correct as per the logic given by you (both contractual & technical column "Y") and the ranking is also correct as it is the 5th lowest price.

Thanks
 

Jet Fusion

New Member
Hi Nebu & GraH - Guido

Thanks for feedback, not sure what is going on my side, I have checked and the setting is on automatic calculation.

When i change more than one row to be Y & Y under the contractual and technical it does not seem to highlight the correct row in the ranking column to match the top in F1 & 2.

Thank you for the time and assistance.

Jet
 
Top