Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Min of range where other col has a value
Hi, I'm trying to pull the min number from a col, where the value in another
col is defined. ie. A 5 B 2 A 2 C 7 A 10 B 1 C 5 I need to pull the min for A. I looked up DMIN but the Help doesn't do my any good. Thought combo of MIN and SUMPRODUCT might work but can't get the syntax right. Anyone know how to do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Min of range where other col has a value
Try this array** formula:
=MIN(IF(A1:A7="A",B1:B7)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) Biff "Pete Derkowski" wrote in message ... Hi, I'm trying to pull the min number from a col, where the value in another col is defined. ie. A 5 B 2 A 2 C 7 A 10 B 1 C 5 I need to pull the min for A. I looked up DMIN but the Help doesn't do my any good. Thought combo of MIN and SUMPRODUCT might work but can't get the syntax right. Anyone know how to do this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Min of range where other col has a value
Yep! That did the trick.
Thanks Biff! "T. Valko" wrote in message ... Try this array** formula: =MIN(IF(A1:A7="A",B1:B7)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) Biff "Pete Derkowski" wrote in message ... Hi, I'm trying to pull the min number from a col, where the value in another col is defined. ie. A 5 B 2 A 2 C 7 A 10 B 1 C 5 I need to pull the min for A. I looked up DMIN but the Help doesn't do my any good. Thought combo of MIN and SUMPRODUCT might work but can't get the syntax right. Anyone know how to do this? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Min of range where other col has a value
You're welcome. Thanks for the feedback!
Biff "Pete Derkowski" wrote in message ... Yep! That did the trick. Thanks Biff! "T. Valko" wrote in message ... Try this array** formula: =MIN(IF(A1:A7="A",B1:B7)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) Biff "Pete Derkowski" wrote in message ... Hi, I'm trying to pull the min number from a col, where the value in another col is defined. ie. A 5 B 2 A 2 C 7 A 10 B 1 C 5 I need to pull the min for A. I looked up DMIN but the Help doesn't do my any good. Thought combo of MIN and SUMPRODUCT might work but can't get the syntax right. Anyone know how to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions |