Thread: how do you number Rows A-Z then AA-ZZ
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default how do you number Rows A-Z then AA-ZZ
In A1 enter:

=LEFT(ADDRESS(COLUMN(),ROW(),4),LEN(ADDRESS(COLUMN (),ROW(),4))-1)

and copy down
--
Gary''s Student - gsnu200790


"Rebecca Potter" wrote:

I need to list the rows with A, B, C, at the start and then continuing with
AA, BB, CC - any suggestions please - fill down doesn't work!
Reply With QuoteReply With Quote