ExcelBanter - finding repeated numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - finding repeated numbers (https://www.excelbanter.com/excel-worksheet-functions/95671-finding-repeated-numbers.html)

[email protected]

finding repeated numbers

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

Max

finding repeated numbers

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

All times are GMT +1. The time now is 03:57 PM.