Finding unique records from a list.

S

Shanks

I have data in List where there is a filed TAG Number and contains numbers like

0405-115560
0405-115588
0304-100560
0304-152560
.....like wise

I want to now find out if all the numbers are unique and that there is no
dulicate number in this field.

There are around 600 to 1500 rows of data in a list.

Can I have a clue to get over this problem ?

Thx
Shanks
 
B

Biff

Hi!

Here's another way to quicky tell if you have duplicates:

Enter this array formula with the key combo of
CTRL,SHIFT,ENTER:

=IF(SUM(COUNTIF(A1:A10,A1:A10))>COUNTA
(A1:A10),"Duplicates","No duplicates")

You can then use conditional formatting to highlight the
duplicates:

Select the range A1:A10
Goto Format>Conditional Formatting
Formula is: =COUNTIF(A$1:A$10,A1)>1
Click the Format button and select a fill color to
highlight the duplicates.
OK out

Biff
 
M

Max

Another way to play ..

Assuming this is in col A, A1 down
0405-115560
0405-115588
0304-100560
0304-152560
....like wise
Click to expand...

Put in C1:

=IF(A1="","",IF(COUNTIF($A$1:A1,A1)>1,"",ROW()))

Copy C1 down to say, C2000,
to cover max expected data range in col A

Put in D1:

=IF(ISERROR(SMALL(C:C,ROWS($A$1:A1))),"",INDEX(A:A,MATCH(SMALL(C:C,ROWS($A$1
:A1)),C:C,0)))

Copy D1 down to D2000

Col D will return the list of uniques from col A

Just copy col D and then paste special as values
elsewhere as may be needed.
 
B

Brian

Hey I would just like to know if it is possible to reset a cell depending in
another cell. ie I would like to have a yes/no option and if yes a value is
given in the next cell, however if no is chosen and the next cell has a
number I would like to use a function somewhere else that will reset that
cell.
 
Top