Sorry for my ignorance. I extended the formula and it works! THANKS!
--
mrs luke


"Ashish Mathur" wrote:

Hi,

You can use the following formula

IF(COUNTIF($B$1:$B$5,F1)=1,"Duplicate","Unique")

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Mrs Luke" wrote in message
...
I am trying to do a function that will look for and tell me if there is or
is
not a duplicate number on a spread sheet.
EX: column B has numbers in accending order.
column F has numbers in accending order. Some of these numbers will
be duplicates of some numbers in column B but not necessarily on the same
row.
I want a function in say column J that will tell me if a number in cell F1
is found in any cell in coumn B.
I tried the Logical IF function but that only seemed to work the the
numbers
were on the same row. I wrote is as =+IF(B38=F36:F40,"on report","not on
report").

Can anyone help me?
--
mrs luke