A Afarag Member Sep 18, 2014 #1 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,
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,
Luke M Excel Ninja Staff member Sep 18, 2014 #2 If data is in A1:A10000, then in B1: =A2+COUNTIF(A$1:A1,A1)-1 Copy down as far as needed.
Swapnil Member Sep 19, 2014 #3 Luke M said: If data is in A1:A10000, then in B1: =A2+COUNTIF(A$1:A1,A1)-1 Copy down as far as needed. Click to expand... @Luke M Sorry to interrupt , But I think formula in B1 should be =A1+COUNTIF(A$1:A1,A1)-1 Please correct If my understanding is wrong
Luke M said: If data is in A1:A10000, then in B1: =A2+COUNTIF(A$1:A1,A1)-1 Copy down as far as needed. Click to expand... @Luke M Sorry to interrupt , But I think formula in B1 should be =A1+COUNTIF(A$1:A1,A1)-1 Please correct If my understanding is wrong
Luke M Excel Ninja Staff member Sep 19, 2014 #4 Nope, you're absolutely right Swapnil. I 'fat-fingered' that one.
A Afarag Member Sep 19, 2014 #5 Hi @Luke M & @Swapnil thanks a lot your formula is getting the right outcomes accurately