• 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
 
Top