YEEEESSSS! it works! Just out of interest, not being too technically-minded,
how do the $ signs affect the formula?
many thanks btw :)))))

"Bob Phillips" wrote:

=IF(A1=$F$1,1,0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"mutie" wrote in message
...
seems to work ok up to a point. However, taking your example, when I try
to
fill or copy down to B100, the formula in each cell changes, F1 becoming
F2,F3....and so on. Is there any way of stopping this from happening?

"MartinW" wrote:

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