avi wrote:
Hello,
I have an array (Array1) of values derived from an Excel range
Is there some function for knowing the number of items smaller than a
certain value without looping (something like CountIf for a range)?
Thanks
avi
Not sure what you mean by "without looping"; but if the functions in the
freely downloadable file at
http://home.pacbell.net/beban are available,
without having to code the looping (because it's built in to the
function), you could use
=ArrayCountIf(myArray, certainvalue, "<")
Alan Beban