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