R
RincewindWIZZ
Sorry if this has been asked before but I failed to find it.
I want to write a small function for use in an array function.
The function (MinChar) returns the smallest lexicographically of its
parameters (like MIN but works with text). I want to use this function
in an array formula
={MinChar(IF(E10:E14>B8,E10:E14))}
so that I get the smallest value that is bigger than B8.
={MIN(IF(E10:E14>B8,E10:E14))} where the values are all numeric works
just fine so why does the custom function not work?
I have tried parameters as a range or as a parameter array but I get
#VALUE every time.
MinChar(E10:E14) works fine.
TFAI
I want to write a small function for use in an array function.
The function (MinChar) returns the smallest lexicographically of its
parameters (like MIN but works with text). I want to use this function
in an array formula
={MinChar(IF(E10:E14>B8,E10:E14))}
so that I get the smallest value that is bigger than B8.
={MIN(IF(E10:E14>B8,E10:E14))} where the values are all numeric works
just fine so why does the custom function not work?
I have tried parameters as a range or as a parameter array but I get
#VALUE every time.
MinChar(E10:E14) works fine.
TFAI