Originally Posted by
benjamings
Impressive. That worked. Thanks so much.
Is there also a way to change the formula so that instead of adding A,B,C,D it adds W,X,Y,Z?
Sure... Just play with number 64 in formula and write some bigger one...
For example:
=A1&SUBSTITUTE(CHAR(86+ROUNDUP(COUNTIF($A$1:A1,A1)/4,0)-1),"V","")
Will give you W as first one (also change @ to prior character of W which is V)
Note that there shouldn't be more than 4 instances or after WXYZ you'll get :
test[
test[
test[
test[
test\
test\
test\
test\
test]
test]
test]
test]
test^
test^
test^
test^
test_
test_
test_
test_
Bookmarks