Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MINIF function
Is it possible to create a MINIF UDF ?
I'm trying to create a UDF that finds the smallest number in a range for a given criteria. =MINIF(range_or_array_constant,criteria) For example, =MINIF({0,1,2,3},"0") would return 1. Any ideas ? - Ronald K. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MINIF function
Pls find the following (The use is linke SUMIF function)
Function MINIF(MyRange As Range, Criteria As String) 'The following line must be on single line MINIF = Application.Evaluate("=MIN(IF(" & MyRange.Address & Criteria & "," & MyRange.Address & "))") End Function |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MINIF function
Javed,
Thanks for the quick reply. Is it possible to get this to work with an array constant in addition to a range reference ? For example, =MINIF({0,1,2,3},0) - Ronald K. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
MINIF function
I am sorry.I Think it is beyond my knowledge.
I susupect it is beyond VBA.Shall be very eager to know if anyway is there. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there any funcion like a @maxif or @minif? | Excel Worksheet Functions | |||
minif | Excel Worksheet Functions | |||
MINIF ???? | Excel Worksheet Functions | |||
Minif / Maxif ? | Excel Worksheet Functions | |||
MINIF /MAXIF Or something similar | Excel Discussion (Misc queries) |