Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find the smallest amount
This is an array formula that must be entered using ctrl+shift+enter and pls
notice the ranges are the same size. =MIN(IF((O14:O24="dog")*(P14:P24="black"),Q14:Q24) ) -- Don Guillett Microsoft MVP Excel SalesAid Software "Brian" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Smallest entry but excluding zero | Excel Worksheet Functions | |||
Find Smallest and Largest. | Excel Worksheet Functions | |||
Find X number of smallest values in a range | Excel Worksheet Functions | |||
trying to find the smallest with dynamic column changes | Excel Discussion (Misc queries) | |||
find smallest number not equal to 0 | Excel Worksheet Functions |