Assuming that you want to start in A1? One way:
- Code: Select all
=123+(CEILING(ROW(),4)/4)-1&"-"&CHAR(64+MOD(ROW()-1,4)+1)
and copy down.
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
=123+(CEILING(ROW(),4)/4)-1&"-"&CHAR(64+MOD(ROW()-1,4)+1)
Return to General Excel Questions
Users browsing this forum: No registered users and 247 guests