sorry for the lack of experience and knowledge in excel macros. If anyone knows of some code that can complete this task please direct me to the source!
I need to find all duplicates in Column A, for any number of rows, and then add a incremental _# so they are no longer duplicates.
Column A
A
A
A
b
b
c
C
C
c
Column B
A_1
A_2
A_3
b_1
b_2
c_1
C_2
C_3
c_4
If it's just that, you can use.
b1and drag down.
=A1&"_"&Row()
Then you never get duplicated values.
Mark that this is not the same result as you posted.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
That is close, and I actually came across that solution, but the entire issue revolves around grouping the duplicates and incrementing from the start of each group
The dutch formula is
The English formula should be=$A1&"_"&AANTAL.ALS($A$1:$A1;$A1)
b1And drag down.=$A1&"_"&sumif($A$1:$A1,$A1)
I have to change the formula (use the one below):
b1=$A1&"_"&countif($A$1:$A1,$A1)
Last edited by oeldere; 07-23-2012 at 04:45 PM. Reason: I have to change the formula (use the one below):
Thank you very much. This is so so close to being perfect. I need to add an IF statement to check is Column A has no duplicate, if it doesn't than concatenate no value.
results in=$A1&"_"&countif($A$1:$A1,$A1)
Column A
a
b
b
c
d
d
d
d
e
Column B
a_1
b_1
b_2
c_1
d_1
d_2
d_3
d_4
e_1
Would like Colum b to equal
a
b_1
b_2
c
d_1
d_2
d_3
d_4
e
I don't get the question.
You rename collumn A to an non duplicated collumn B.
Why should you want to change collumn A (it has duplicated values in it)?
---------- Post added at 04:11 PM ---------- Previous post was at 04:06 PM ----------
the dutch version is
b1The english version should be:=ALS(AANTAL.ALS($A$1:$A$17;$A1)=1;$A1;$A1&"_"&AANTAL.ALS($A$1:$A1;$A1))
b1Please reply if this is what youre up to.=if(countif($A$1:$A$17,$A1)=1,$A1,$A1&"_"&countif($A$1:$A1,$A1))
Last edited by oeldere; 07-23-2012 at 05:15 PM.
Sorry I wasn't clear. I hope this helps. If the left column doesn't not have a duplicate, like a and d, then I would not like to concatenate anything.
a a c c_1 c c_2 c c_3 d d e e_1 e e_2
It is not that is not clear, I don't understand why you want it that way.
Anyway, it is your question.
See the solutions in #6.
Sorry I dont know why it didn't work the first time I tried it...but post #6 works perfectly now. Thank you very much oeldere!
Glad I could help. Thanks for the reply.
If the question is solved, will you mark your question as solved?
If you have (other) questions, just ask.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
seattlemicah 
Register To Reply
Bookmarks