• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

add 1 to the duplicated value

Afarag

Member
Dears,

i have some codes like
8246441691
8123041725
more and more etc
some of these codes are duplicated, i ask if "8246441691" is duplicated the first code still as exist but add 1 to its duplicate to be "8246441692"

this code inserted from "A1:A10000"

Thanks,
 
If data is in A1:A10000, then in B1:
=A2+COUNTIF(A$1:A1,A1)-1
Copy down as far as needed.
 
Back
Top