![]() ![]() ![]() Once entered into the first cell correctly, they can be filled or copied down or right just like any other formula. If entered correctly, Excel with wrap the formula in braces (e.g. ¹ Array formulas need to be finalized with Ctrl+ Shift+ Enter↵. Step 3 - Go to the cell you want you data validation and use Data ► Data Tools ► Data Validation. Step 2 - Go to Formulas ► Defined Names ► Name Manager and create a new name. =IFERROR(INDEX(A$2:INDEX(A:A, MATCH("zzz",A:A )), MATCH(0, COUNTIF(Z$1:Z1, A$2:INDEX(A:A, MATCH("zzz",A:A ))&""), 0)), "")įill down until you run out of names and then a few more rows to allow for future expansion. Step 1 - With the original names in column A, put this array formula¹ somewhere off to the right in the second row. ![]()
0 Comments
Leave a Reply. |