" 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
---