Count certain values in numeric array

A

avi

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
 
J

Jarek Kujawa

sorry but i can't think of any solution that does not loop through an
array

to me you HAVE to loop through an array
 
A

Alan Beban

avi said:
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
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populating 2-D array w/ Application.[Function] results 1
Return values from multidimentsional array 4
Recode values 4
Arrays and scattered cell values or another way? 16
Strange pasting array to cells behavior 2
Range to array excluding null values 3
Passing an array in a user defined function 2
CSE with function returning an array? 2

Top