Adapted from John Walkenbachs EXCEL FORMULAS series published by Wiley Sons. The SERIES formula takes the following syntax. Select part or all of the formula type in the text you want there instead and press Enter to apply the changes or sometimes to cause an error.
Kutools for Excel - Includes more than 300 handy tools for Excel.
Put your cursor in the cell at A1. Select part or all of the formula type in the text you want there instead and press Enter to apply the changes or sometimes to cause an error. The series formula is a text-based Excel formula like any other. The source data for that series if it comes from the same worksheet is.