excel - How to increment duplicate values from 1 to n by criteria? -


let's have list of duplicate values in column such as:aaabbaacabc. ...aac. want excel rank respectively first a1,the first b b1 second a2 , second b b2 , forth until a(nth) , b(nth). , additional should automatically rank a(nth+1). same thing b c etc. note should able enter new value such x automatically rank x(nth+1) or x1 if did not exist in table before.

hoping made myself understood. waiting me. vba or array formulas have no preference once can realise want.

note found way sorting them in accending order can't match additional value @ end of data base.

thanks.

i assuming data in column "a". enter formula in column "b" , copy formula till row want.

=a1 & if(a1="","",countif($a$1:a1,a1)) 

Comments

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

asp.net mvc - breakpoint on javascript in CSHTML? -