Duplicates

[proficient]

I want to find duplicates numbers in a range

Excel Workbook
	A	B	C	D
1	1		1	4
2	2		2	6
3	3		4	3
4	4
5	6
6	1
7	2
8	2
9	4
10	65
11	1
12	2
13	2
14	4
15	25
16	1
17	2
Duplicates Value

 

[proficient]

Thank you very much Marcelo Branco, FormR, norulen & mirabeau

 

[norulen]

Glad that i could contribute
But would suggest you to post the solution which worked for the best for other people's benefit who might be searching for this thread in the future

 

[abmati]

Try the following formulas in B1, C1 and D1 cells and copy it to down the rows (valid for 100 rows, please change if required)

B1==IF(COUNTIF(A$1:$A$100,A1)=1,"X",IF(COUNTIF($A1:A$2,A1)=1,A1,"X"))
C1=IFERROR(SMALL($B$2:$B$101,ROW()),"")
D1=IF(C1="","",COUNTIF($A$1:$A$17,C1))

Regards,

A.B. Mati