First, there was an extra closing paren in your formula. It should have read:

=IF(COUNTIF($F$2:$F$20,B2)=1,"remains on report","fell off report")

And = is the symbol for "greater than or equal to"

So if the number of times the value in B2 shows up in F2:F20 is greater than or
equal to 1 (it appears at least one time), then return "remains on report". If
the value is 0 (it doesn't appear), then show "fell off report.

I think I would have used:

=IF(COUNTIF($F$2:$F$20,B2)0,"remains on report","fell off report")

But that's probably more of a personal preference.

Mrs Luke wrote:

I have numbers in column F and I want to see if they are duplicated anywhere
in column B. I was given a formula that seems to work but I do not
understand part of the formula. The part I want to know what is represents
is =1
The formula is as follows:
=IF(COUNTIF($F$2:$F$20),B2)=1,"remains on report","fell off report")
What does greater then or equal to 1 mean?
--
mrs luke

--

Dave Peterson