Producing a list

[Andyc55]

I need to produce a column of two figure id codes in Excel 2007, starting with AA, AB etc, ending in ZZ.
Is there an "easy" way to do this, using Fill, or AutoFill (or something else), or will I need to type them all in?
Any help will be gratefully accepted.
Thanks
Andy

 

[jeffreybrown]

Andy,

Not quite sure I understand what you are trying to achieve. Could you post a small sample?

 

[mgirvin]

Dear Andyc55,

Put this formula in A1 and copy it down to A676:

=LEFT(ADDRESS(ROW(AA1),COLUMN(AA1)+ROWS(A$1:A1)-1,4),2)

 

[Andyc55]

Thyanks, Mike. Just what I needed.

Thanks for the reply, Jeff. Mike's formula will probably explain what I meant better than I could.
Regards
Andy