Question: how to create a list formula in excel?
Answer: Click the Formulas tab. In the Defined Names group, click the Create From Selection option. In the resulting dialog, check Top Row (if necessary), and Excel will use the header text to name the range Shelf_Code_List (Figure C).