View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brian Brian is offline
external usenet poster
 
Posts: 683
Default Find the smallest amount

Is there a formula I can use to tell me the smallest amount for a list of
values?
For example:

Column A B C
Dog Black $100
Cat Black $50
Dog Black $50
Dog White $25

I want a formula that will tell me the smallest value for Dog & Black is $50