is there any worksheet function that can be used to find a repeating number in a column of numbers.
A aswini77 Jun 23, 2006 #1 is there any worksheet function that can be used to find a repeating number in a column of numbers.
M Max Jun 23, 2006 #2 [email protected] said: is there any worksheet function that can be used to find a repeating number in a column of numbers. Click to expand... 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"
[email protected] said: is there any worksheet function that can be used to find a repeating number in a column of numbers. Click to expand... 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"
