I am trying to number a spreadsheet to keep track of ticket sales. These numbers will fill column A. The series should look like:
1A 1B 1C 1D 1E 1F 1G 1H 2A 2B 2C 2D 2F 2G 2H and so on until I reach 100H. Is there an easy way to do this?
I am trying to number a spreadsheet to keep track of ticket sales. These numbers will fill column A. The series should look like:
1A 1B 1C 1D 1E 1F 1G 1H 2A 2B 2C 2D 2F 2G 2H and so on until I reach 100H. Is there an easy way to do this?
Last edited by SueBrassel; 01-16-2014 at 02:20 PM.
Formula:Please Login or Register to view this content.
Try this one
Last edited by arlu1201; 01-17-2014 at 12:25 AM. Reason: Replaced answer.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
popipipo that was most excellent! It worked great. How can I use that formula while leaving the cell A1 blank so I can have a title?
This appears to work. Enter in A2 and copy down.
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
=ceiling(rows($a$1:a1)/8,1)&char(65+mod(rows($a$1:a1)-1,8)) start anywhere you want
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks