finding repeated numbers

is there any worksheet function that can be used to find a repeating
number in a column of numbers.

"aswini77@yahoo.com" wrote:
> is there any worksheet function that can be used to find a repeating
> number in a column of numbers.

One way is to flag numbers which repeat in an adjacent col,
then use autofilter to filter the flag

Assuming numbers in A2 down,
Put in B2: =IF(COUNTIF(A:A,A2)>1,"R","")
Copy down

Then do a Data > Filter > Autofilter on col B
and filter out "R"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---