Finding unique records from a list.
 

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

one way is
introduce a heading
highlight all the no.s and the hading
data-filter-advance filter- both input and criteria range is highlighted
range-
copy to different location-unique records only


Shanks wrote in message
...
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

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

-----Original Message-----
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
.

Another way to play ..

Assuming this is in col A, A1 down

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

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.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Shanks" wrote in message
...
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

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.

"Shanks" wrote:

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