Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count certain values in numeric array
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count certain values in numeric array
for "3":
Application.WorksheetFunction.CountIf(Selection, "<" & 3) On 23 Mar, 21:38, 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count certain values in numeric array
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 On 23 Mar, 21:38, 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count certain values in numeric array
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count certain values in numeric array
great utility!
Thanks Avi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Programming | |||
count and arrange cell numeric values | Excel Worksheet Functions | |||
count and arrange cells have numeric values | Excel Programming | |||
Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
How to use an array or matrix to return text vs. numeric values | Excel Worksheet Functions |