Good day everyone,
I have table with 8 suppliers pricing in columns G to N. I want to find the lowest price among all suppliers but if the price is greater than my current cost in column F, then I want to return the text 'Current Price" in Column O. Please see table below.
Capture.JPG
Please Login or Register to view this content.
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
Thank you very much. One last request: How can I auto-highlight the lowest prices for each row. for example the lowest price for row 2 is for supplier Omnitech at $5.91. How would I auto-highlight that price under Omnitech.
Try using the following formula as a conditional formatting rule: =MIN($F2:$N2)=F2 applied to the range F2:N31
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks