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:E14B8,E10:E14))}
so that I get the smallest value that is bigger than B8.

={MIN(IF(E10:E14B8,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


--
RincewindWIZZ
------------------------------------------------------------------------
RincewindWIZZ's Profile: http://www.excelforum.com/member.php...o&userid=20622
View this thread: http://www.excelforum.com/showthread...hreadid=373901