Select the data and do Data / Sort and choose an option
If you just want a formula for the lowest then =MIN(Your_Range)
or even
=SMALL(Your_Range,1) for smallest
=SMALL(Your_Range,2) for 2nd smallest
=SMALL(Your_Range,3) for 3rd smallest etc
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Robin" wrote in message
...
I have a range of cities, and trucking companies. They are offering theri
prices for ninety cities that we ship to in the us. What function or forumla
do I use to sort them by the lowest price per city, second lowest, etc.?
please help!!
Robin
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.789 / Virus Database: 534 - Release Date: 07/11/2004