Find a range of numbers in an array

[fordfan485]

I have array X, which consists of numbers that range from about 1000-15000.

I want to create array Y with all the numbers from array X that are less than or equal to 12000.

How do I do this?

 

[IRstuff]

You need to write a program that copies the desired numbers from one array to the other

TTFN

FAQ731-376

 

[PetieSmo]

fordfan,

There are several ways to skin this cat, but the ones I can think of involve some form of programming, as IRStuff said. If you need some help with this, we'd be happy to generate a sample program in a worksheet for you.

Good luck
Pete

 

[excognito]

try the attached

 

[fordfan485]

Thanks excognito, that program does what I was trying to do perfectly.