Filtering

[Andy Gregory]

can anybody tell me how to remove or at least identify a
group of numbers in a range from a data set. I have tried
using the custom auto filter but it wont do anything 9i
might be doing it wrong). Any advice would br grand.

Cheers, Andy.

eg below.

5360
4470
3420
2970
3230
3790
4240
5350
5270
5190
4700
5240
6500
7300
6900
7000
6500
5400
5000
4100
3500
3300
2870
3500

3460
2900
2100
1980
1360
960
780
110
110
1310
1760
1800
2050
2450
2850
2940
3020
3390
3450
1600
290
-300
-880
-1670

-2050
-2240
-2700
-2850
-3040
-2830
-1670
-900
-810
-310
300
750
1150
1820
2780
3160
2480
1960
650
600
230
-770
-2230
-2670

-2890
-2950
-3220
-3390
-3360
-3680
-3680
-3280
-2360
-780
20
1220
1760
1570
590
-1690
-1580
-2420
-2800
-2860
-3280
-3420
-3600
-3770

i'd like to remove all values from the above that are
less than 1000.

 

[Frank Kabel]

Hi Andy
some ideas:
1. Using autofilter
- Give this column a heading and goto 'Data - Autofilter'
- In the appearing listbox choose 'Custom' and filter all values <1000
- Delete these filtered row
- remove the filter

2. Sorting:
- Sort this range
- Mannualy delete the entries

 

[Guest]

If i sort the data and delete the values manually, is it
possible to then unsort them? The data i am working with
is hourly tepmerature data, so it has to be in the write
order.

THanks for your help

 

[Frank Kabel]

Hi
if you need the existing sorting use the filter method