LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default Finding lowest price

I'm hoping someone can help me with a formula that will determine from
4 non-consective columns, ie, F,H,J,L, the lowest price of the four
and place the ranking '1-4 lowest to highest' in the column
preceeding. E,G,I,T.

I'm looking to rank the bid prices from 4 vendors 1-4 for each food
item placed on bid. We are required to take the lowest bid when
ordering these food items (school cafeteria). Their bid prices are in
cols F,H,J,L under their column headings, Garner, Quality, Sysco,
Tankersley. The food items are in Column A2:A700.

I'd really appreciate any input.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Highlight lowest price in a row. chadboehne Excel Discussion (Misc queries) 6 December 17th 07 05:04 PM
Calculation based on lowest price [email protected] Excel Discussion (Misc queries) 6 December 11th 07 09:47 PM
CF to highlight lowest price in row kale Excel Worksheet Functions 5 December 1st 06 07:45 PM
Finding lowest low in a pullback sam mcgee Excel Discussion (Misc queries) 1 January 8th 06 09:23 PM
How can I get the lowest price, second lowest etc. from a range o. Robin Excel Worksheet Functions 2 November 9th 04 12:23 PM


All times are GMT +1. The time now is 03:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"