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
|