macro highlight duplicate values

[max_max]

Hello to all,
I found online this macro highlighting duplicate values:

Please Login or Register  to view this content.

you can a change?
Now if this is a duplicate value is highlighted.
The change is to add the word "duplicate" in cell C
If not duplicate add the word "not duplicate."
I hope I was cpmprensibile.
A greeting,
max_max

[Keebellah]

Hi, it's quite simple,
Just add a line to the code, when you set the highlight to the color you use also add the value in the same row for column C

Please Login or Register  to view this content.

I hope you understand my short explanation, my Italian is not too good to write in

[max_max]

Hello keebellaH.
Thank you for that answer but in point of the macro must enter your edit?
max_max

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[max_max]

Hello john davis h.
the macro does not appear "duplicate or not duplicate"
max_max

[Keebellah]

Hi max, John's code is what I meant, maybe you should attach a sample file.

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[max_max]

You do not see 'duplicate not duplicate "in column C.
max_max

[Keebellah]

What's the font color?

[max_max]

Attaching the example.
remove:
'Application.ScreenUpdating = False
'Application.ScreenUpdating = True
To check
max_max

prova_duplicati.xls

[Keebellah]

Well you are deleting the sheet so you never see it.
I don't know why you have the extra sheet added, but you delete it in the end

Please Login or Register  to view this content.

Remove the red line and see, but then the answer is NOT in the Foglio1

Why the macro, you can do it with formulas

[Keebellah]

Tenta questa possibilitá

[jindon]

Is this kind of how you want it?

Please Login or Register  to view this content.

[max_max]

Hello keebellah,
"duplicate duplicate" must be visible in the sheet 1. The Sheet2 should delete.

Hello Jindon your macro is good but with more than 30,000 rows excel crashes, with my old computer that has little RAM
max_max

[jindon]

Try the codes and use faster one

Please Login or Register  to view this content.

[max_max]

Hello jindon,
The second macro "Test2" is really fast.
Many thanks.
You can add to "test2" also "not duplicated".
Thanks again.
max_max

[jindon]

You can add to "test2" also "not duplicated".

change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[jindon]

If that takes care of your original question, select Thread Tools from the menu link above and mark this thread as SOLVED.

[max_max]

Hello jindon.
We are almost at the end of the solution.
Now I have added:

total values (n)
duplicate values (c)
not uplicated values (d)

is exact my change?

Please Login or Register  to view this content.

max_max

[jindon]

Perhaps

Please Login or Register  to view this content.

[max_max]

Hello jindon
Thank you so much and I salute you from Italy.
I hope google translator functions.
max_max
---------------------------------------------------
こんにちはjindon
どうもありがとう、私はイタリアからあなたを敬礼。
私は、Googleの翻訳機能を願っています。
max_max
---------------------------------------------------
Ciao jindon
Ti ringrazio tanto e ti saluto dall'Italia.
Spero che google traduttore funzioni.
max_max

[jindon]

You are welcome and don't forget to mark this thread "Solved".

[max_max]

Hello jindon.
The macro is perfect.
I entered the macro in a new workbook and between 2 sheets there is a hyperlink.
I do not understand why after starting the macro this link disappears.
I am attaching example.
max_max

prova_duplicati_06_01_16.xls

[max_max]

Hi to all.
A help for change macro?
max_max

[jindon]

Please Login or Register  to view this content.

[max_max]

Hi jiindon
the iperlink head but "duplicate" is also in the cells
emty
max_max

[Keebellah]

I guess your Google translate isn't working correct.
What are you trying to tell us?

[max_max]

Hello,
the hyperlink between the sheets now with the new macro works.
Always remains the word "duplicate" although the cell A is empty.
See attached picture.
I hope google translator now functions.
max_max

Appunti01.jpg

[Keebellah]

The hyperlink was not in the first post.
Well, you will have to add a check to stop when the cells are empty
I'll check the prova_duplicati_06_01_16.xls file and see what I can do for you.
I'm sure Jindon has the asnwer too
By the way, are you using excel 2003 or earlier?

[Keebellah]

There is something strange.
It does not ALWAYS check the empty rows.
The way Jindon fills the arrays is fine but why it sometimes goes all the way down to row 200, I do not understand
I'll write some code the way I would do it to see what happens

[max_max]

Hello Keebellah
here at home excel 2007 in my office excel 2003.
max_max

[Keebellah]

Okay, we keep the xls files

[jindon]

max_max

You should have uploaded the true file in the first place, otherwise you can not get the solution what you have in your mind.
I can not read inside your brain....

Please Login or Register  to view this content.

[max_max]

Hello jindon,
thanks now works well.
Only now a change.
The values found are displayed by your macro:

Please Login or Register  to view this content.

They are not exact.
I modified the macro like this:

Please Login or Register  to view this content.

max_max