finding repeated numbers

A

aswini77

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

Guest

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

---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Idetnifying repeats in a column 1
Find a number on another worksheet 1
Repeating numbers in same cell 9
Formula (or code) return the largest number of duplicates in a list. 16
repeated values 1
Numbers of repeats of a string 11
Number repeated in an array 1
Finding Repeated Words 4

Top