For the life of me, I can't figure out how to search for this problem because it's so specific. I thought I could find something similar and tweak it to what I need, but so far no luck.
I need to fill a sequence of numbers down a column next to another column of data, but the auto-fill sequence looks like this:
..etc
Data B-1-1-1 Data B-1-1-2 Data B-1-1-3 Data B-1-1-4 Data B-1-1-5 Data B-1-2-1 Data B-1-2-2 Data B-1-2-3 Data B-1-2-4 Data B-1-2-5
Basically just put the formula into the first cell, then clicking and dragging it down as far as I need to. Is such a formula possible, or is this a bit too complicated for Excel?
(Always starts with "B-1-", then goes "1-1" up to "1-5", then changes to "2-1" to "2-5", then "3-1 to "3-5"... and so on).
Bookmarks