Create an alphanumeric sequence

**shg** · 09-15-2009, 12:05 PM

So for the first column I want it to list a1a1-a1a10 and then in the second column a1b1-a1b10 and so on

That's what you asked for ...

**footsoreaxe** · 09-15-2009, 12:28 PM

Originally Posted by shg

That's what you asked for ...

I know that's what I asked for, but I was also wondering if you could give me the formula for just listing it in one column as well (or do you want me to create a new thread?).

Thanks.

**shg** · 09-15-2009, 02:57 PM

= address( mod( int( (row() - 1) /  260), 10) + 1, 
           mod( int( (row() - 1) / 2600), 26) + 1, 4) 
& address( mod(       row() - 1,     10)      + 1, 
           mod( int( (row() - 1) /   10), 26) + 1, 4)

**suppaiyah** · 09-16-2009, 08:29 AM

deleted..deleted

**cory07061989** · 11-25-2009, 02:31 AM

I need to create a spread sheet that lists as so

A-1A
A-1B
A-1C
A-2A
A-2B
A-2C

So it will be A-1A-Z-8C Can anyone help me out by giving me the formula for it?