New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Creating a series

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Re: Creating a series

Postby pecoflyer » Thu Jul 14, 2016 9:45 am

Hi
please do not hijack existing threads, even your own.
To get better and faster answers, always create a new thread for a new question eventually adding a link to an existing thread.

Cheers
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010

Re: Creating a series

Postby Kevin UK » Fri Jul 15, 2016 12:33 am

Hi

Try the following, in A1 & copy down.

Code: Select all
=TEXT(CEILING(ROW()/4,1),"000000")&"-"&CHAR(MOD(ROW()-1,4)+1+64)
  • 0

Regards

Kevin
Kevin UK
Excel Master
 
Posts: 568
Joined: Jun 24, 2012
Reputation: 86
Excel Version: 2016


Return to General Excel Questions

Who is online

Users browsing this forum: Google [Bot] and 33 guests

cron