Auto fill

  • Thread starter Thread starter hotelier
  • Start date Start date
H

hotelier

I would like to autofill in the sequence

00AA-00AZ, 00BA - 00BZ all the way to 99ZZ.

Autofill doesn't recognise this as a logical sequence, in fact I'm surprised
that it doesn't seem to recognise A-Z as a sequence.

Is there a formula i can copy down to fill these in?

Thanks

Mick

England
 
Hi Mick

Monster formula in a row 1 cell:
=INT((ROW()-1)/6760)&MOD(INT((ROW()-1)/676),10)&CHAR(INT((MOD(ROW()-1,676))/
26)+65)&CHAR(MOD(ROW()-1,26)+65)
fill down. 96YP is as far as it goes in row 65536 though.

HTH. Best wishes Harald
 
I think the following method helps you.

1. Click [Tools] on the menu
2. Click [Option]
3. Select the tab User Created Lists
4. Make a list

I use Excel not in English but in Japanese, so the captions may be
different from your exvironment.

Norihiro Kamae
 
Thank you so much Harold and Norihiro Kamae. I have tried the formulae and
it is exactly what I wanted.

Not only that but it's advanced my understanding of formulae so much. I'm
afraid I'm just one of those people that has to break it all down so that I
fully understand what each bit is doing.

Best wishes

Mick
 
Glad to hear that Mick.
The trick is INT and MOD (see Help on those). The rest is just patchwork.

Best wishes Harald
 
Back
Top