Filtering Data

  • Thread starter Thread starter Lodgey
  • Start date Start date
L

Lodgey

Hi guys,

I have a problem that I was hoping you could help me with. I hav
excell files that are 100 rows down with floating point number
(ranging from -500 to 2000) across (see below for an example).

What I need to do is to pull out all the values 0<x<500 keeping th
format of the rows intact.

Any help would be greaty appreciated

Lodgey

------------------------------------------------------------------------------------
Example.

0 -383.5 -81.1 96.5 135.5 1381
1 -472.8 126.9 155.8 1135.2
2 -129.2 69.9 119.8 224.9 319.4 874.8
3 -56.8 61.1 102.1 234.3 292.1 867.6
4 -469.1 -442.6 50.5 85.1 227.2 330.3
5 -435.6 -286.2 87.2 126.7 259.8 362.5
6 -109.8 75.8 112.3 223.3 304.3 1207.3
7 -440.7 68.7 119.6 223.9 272.9 878.1
8 61.9 100.1 182.7 1297.7
9 -363.3 -247.9 95.1 124.9 564.6 1339.4
10 -466.1 14.9 100.6 131.8 298.9 334.
 
Assuming your sample data is in B1:G11, in Sheet1 (say)
[disregarding the 1st col: 0,1,2,3... which appears to be a serial listing]

In Sheet2
-----------
Put in B1: =IF(AND(Sheet1!B1>0,Sheet1!B1<500),Sheet1!B1,"")
Copy B1 across to G1, then copy down to G11

B1:G11 will return all the values "0<x<500"

Extend to suit.
 
Back
Top