filtering unwanted numbers

[vck1]

I have a list of about lets say some 5000 numbers, which are randomly generated normally distributed values. I just to want to retain values falling between two boundaries.
How can I do this??

 

[DonkeyOte]

if(and(a1>10,a1<20),a1,"")

 

[Aladin Akyurek]

On 2002-10-08 02:59, vck1 wrote:
I have a list of about lets say some 5000 numbers, which are randomly generated normally distributed values. I just to want to retain values falling between two boundaries.
How can I do this??

How about using Advanced Filter (under Data|Filter)...

aaAdvFilter vck1.xls
	A	B	C	D	E	F
1	Nums			Nums	Nums	Nums
2	1			>2	<5	3
3	2					4
4	3
5	2
6	4
7	5
8	6
9	2
Sheet1

 

[vck1]

thanks it helps