the macro recorder is your friend. Recorded this. See clean up below
Sub Macro4()
'
' Macro4 Macro
' Macro recorded 7/2/2006 by Don Guillett
'

'
Range("A1").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:="2", Operator:=xlAnd
Selection.AutoFilter
End Sub

Sub Macro4cleande()
Range("A1").autoFilter Field:=1, Criteria1:="2", Operator:=xlAnd
do your stuff with the filtered cells see vba help index for special cells
and then visible.
range("a1").AutoFilter
End Sub


--
Don Guillett
SalesAid Software

"mutie" wrote in message
...
thats another good suggestion and seems to work. Unfortunately I have to
do a
similar operation about 8 times with different sets of data in the same
worksheet and then do the same with another 20 sets of worksheets. I'm
trying
to work out how to do it automatically, so that I can then create a macro.
The weird thing is, I can get the program to filter using
=D2<PERCENTILE(D2:D36,0.97)
So, D2 is the start of my data, D36 the end. I've put the formula in J2,
but
when I filter using this, it doesn't filter correctly!

"Don Guillett" wrote:

datafilterautofiltercustomleft window greater thanright window your
figure.

--
Don Guillett
SalesAid Software

"mutie" wrote in message
...
Hi there. I have a series of data from an experiment that I'm trying to
"trim" extreme results from. I have calcuated the 0.97 perecntile, but
I'm
wondering if there's a way to filter out allthe results above that
percentile. The help sheets are pretty confusing and not very well
constructed!