Friday, August 18, 2017

yogi_Find The Lowest Priced Vendors By County

Google Spreadsheet   Post  #2226

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Aug-18-2017
question by: Ben.V
https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!msg/docs/aiqY1HL93QY/p-KBW7kYCgAJ

Search for duplicates in Col B, compare number in Col C, highlight lowest number?

 
This sheet shows the following:
Vendors in column A
Counties in column B
Prices in column C
I often need to review lists like this to find the cheapest vendor in each county. Many counties have more than one vendor. Currently, I have to do this manually.
Here's what I would like a formula to do:
1.  Scan the list of counties in Col B.
2.  Find duplicate county names. This will show where there is more than one vendor per county.
3.  Compare the prices in column C for the duplicate counties.
4.  Highlight the lowest number.
For example:
See Rows 36 and 37.
Two vendors cover Hardeman.
One vendor costs 65. The other costs 95.
I would like the system to find this and highlight the 65.
Thank you very much in advance for any suggestions!!!
Ben