Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I identify duplicated numbers in a large range of cells
I have a large range (column) of cells (3567) which contain Alpha numerical
i.d codes, I want to indentify cells where i.d codes are duplicated |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I identify duplicated numbers in a large range of cells
Assume source data in A2 down
Put in B2: =IF(COUNTIF(A$2:A2,A2)1,"dup","") Copy B2 down to the last row of data in col A to flag duplicates as "dup". You can apply autofilter on col B, choose: dup to retrieve all at one go -- Max Singapore http://savefile.com/projects/236895 Downloads:22,000 Files:370 Subscribers:66 xdemechanik --- "gillman54" wrote: I have a large range (column) of cells (3567) which contain Alpha numerical i.d codes, I want to indentify cells where i.d codes are duplicated |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I identify duplicated numbers in a large range of cells
Have a look at the video named "Using vlookup to Match Lists" over he
http://www.free-training-tutorial.co...n-vlookup.html Or the video named: "Finding duplicate values or unique values with conditional formatting" over he http://www.free-training-tutorial.co...ormatting.html "gillman54" wrote: I have a large range (column) of cells (3567) which contain Alpha numerical i.d codes, I want to indentify cells where i.d codes are duplicated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to compare two lists and identify cells with same numbers in | Excel Discussion (Misc queries) | |||
Can Excel mark or identify duplicate cells in a range? | Excel Discussion (Misc queries) | |||
Identify a range of cells containing dates | Excel Worksheet Functions | |||
HOW DO I IDENTIFY DATA THAT IS DUPLICATED IN TWO SEPERATE WORKSHEE | Excel Discussion (Misc queries) | |||
How do I identify cells with matching numbers within a column. | Excel Worksheet Functions |