View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default Advanced filtering

Hi mutie,

Say your data is in column A1 to A100 and your 0.97 percentile figure
is in cell F1.
in B1 put =IF(A1=F1,1,0) and copy down to B100
You can then use autofilter on column B to select all the zeroes (or all the
ones)
Depending on your setup you may want to use a temporary column
to do this and delete it later.

HTH
Martin