i need a macro to find the duplicate entries made in a column,

I JUST EXPLAIN WHAT I NEED.

COLUMN A
--------------
GLDU4067071
CMBU2386785
BSIU90120366
GLDU7006737
GLDU4067071
TCNU9317748
TCKU9236332
CMBU2386785
KNLU5060868
CMBU2386785


LIKE THIS THOUSAND OF CONTAINER NO'S WILL BE THERE, IN WHICH I NEED TO KNOW
WHETHER ANY ONE IS DUPLICATED IF DUPLICATED

PLS GIVE THE ENTRIES IN COLUMN B AS
"GLDU4067071 DUPLICATED ONCE. "
"CMBU2386785 DUPLICATED THRICE"
ELSE
SHOW " NO CONTAINERS ARE DUPLICATED"

Those who have knowledge in making macros ,pls make a excel in order to get
the concerned result. & send me mail on

Pls make the macro in your own wish, but the result must be some what like
this.

If this macro is ready, my work load will be reduced . so those who know
this pls help me.

Hello,

I suggest to use my UDF lfreq (if you do not have too many entries):
http://www.sulprobil.com/html/listfreq.html

Another approach would be via pivot tables.

Regards,
Bernd

I can easily write the macro, but this is much easy done with a simple formula

copy to B1 and then copy down entire column B. Change A$1000 to be larger
than the last row in column A. If you need a number in the cell rathre than
a formula copy column B and Paste Special Values only from Edit Menu.
=COUNTIF(A$1:A$1000,A1)

"lino" wrote:

i need a macro to find the duplicate entries made in a column,

I JUST EXPLAIN WHAT I NEED.

COLUMN A
--------------
GLDU4067071
CMBU2386785
BSIU90120366
GLDU7006737
GLDU4067071
TCNU9317748
TCKU9236332
CMBU2386785
KNLU5060868
CMBU2386785


LIKE THIS THOUSAND OF CONTAINER NO'S WILL BE THERE, IN WHICH I NEED TO KNOW
WHETHER ANY ONE IS DUPLICATED IF DUPLICATED

PLS GIVE THE ENTRIES IN COLUMN B AS
"GLDU4067071 DUPLICATED ONCE. "
"CMBU2386785 DUPLICATED THRICE"
ELSE
SHOW " NO CONTAINERS ARE DUPLICATED"

Those who have knowledge in making macros ,pls make a excel in order to get
the concerned result. & send me mail on

Pls make the macro in your own wish, but the result must be some what like
this.

If this macro is ready, my work load will be reduced . so those who know
this pls help me.