Thread
:
Auto number w/ different letter-number combos in same column
View Single Post
#
2
[email protected]
Posts: n/a
If you can settle for 2 Col, try this:
In the first Col enter the letter alone
In the second Col enter this formula
=A2&COUNTIF(INDIRECT("a"&ROW()&":"&"a1"),A2)
change the addresses as needed
Ilan
Reply With Quote