Find Duplicates and Add Number of Occurrence

**Jonathan78** · 05-16-2013, 10:05 AM

Hi all,

Lets say I have the following list:

DF
ER
GHJ
YG
ER
KJ
GHJ
ER

I'd like to find a way to look for duplicates and add a number to it:

DF
ER
GHJ
YG
ER1
KJ
GHJ1
ER2

All help is welcome

**zbor** · 05-16-2013, 10:06 AM

Write in next column

Formula:

Please Login or Register  to view this content.

**Jonathan78** · 05-16-2013, 10:10 AM

Hello Zbr,

I was actually looking for a way to get them in the existing range instead of creating a new one.
Sorry for being unclear

**Jonathan78** · 05-16-2013, 11:44 AM

Anyone????

**MickG** · 05-16-2013, 12:09 PM

Try this:-

Please Login or Register  to view this content.

Regards Mick

**Jonathan78** · 05-16-2013, 12:15 PM

Awesome!
many thanks Mick, you helped me allot with this

Find Duplicates and Add Number of Occurrence

LinkBack

Thread Tools

Rate This Thread

Display

Find Duplicates and Add Number of Occurrence

Re: Find Duplicates and Add Number of Occurrence

Re: Find Duplicates and Add Number of Occurrence

Re: Find Duplicates and Add Number of Occurrence

Re: Find Duplicates and Add Number of Occurrence

Re: Find Duplicates and Add Number of Occurrence

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions