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

 

[norulen]

What is your question??

 

[proficient]

Wana find duplicate numbers from a range, like you can see the 1 2 and 4 are duplicates in the range these are my desire result, sorry my mistake i did not mentioned it...

 

[JackDanIce]

Easiest way is to use Advanced Filter to generate a separate list of unique values, have a read of:
How to remove duplicate records or create list of unique records in Excel

 

[proficient]

Easiest way is to use Advanced Filter to generate a separate list of unique values, have a read of:
How to remove duplicate records or create list of unique records in Excel

Jack I want to pick DUPLICATES VALUE not wana remove...

 

[norulen]

How should your output look like?? Should it only throw up unique values?? or you want the duplicates in a seperate column.
If you can post your desired output probably someone will be able to help you out with this one

 

[proficient]

I want duplicate values in a separate column...

 

[norulen]

Try this in Column B2 (Assuming First Row will be header) and drag down

=IF(COUNTIF($A$1:A2,A2)>1,"Duplicate","Unique")

 

[norulen]

Just saw your post i dunno if this serves your purpose

Try this in Column B2 (Assuming First Row will be header) and drag down

=IF(COUNTIF($A$1:A2,A2)>1,"Duplicate","Unique")

 

[proficient]

Try this in Column B2 (Assuming First Row will be header) and drag down

=IF(COUNTIF($A$1:A2,A2)>1,"Duplicate","Unique")

You are getting me wrong...