View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Advanced filtering

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!