Excel’s Custom Lists are great, but you need to drag them to create them. If you have a list that you use frequently why not create a custom function to display it? This has the added advantage of creating a spill range that can then drive other dynamic array formulas.
This technique is ideal for lists that don’t change. Like days of the week (this example) or months of the year. You could use it for lists that change as well as you only need to edit the list in one place – the range name. Be careful using this technique with lists that change – the main issue may be inputs based on the list sequence. Change the lists may impact the inputs made.
If you are not familiar with custom functions check out the link below.
The LAMBDA in the image below will display a vertical list of abbreviated week names as default or if “v” is entered between the brackets. It produces a horizontal list if “h” is used between the brackets – as shown in the image below.
The custom function created is shown in the image below.
The custom function in use is shown below. The default is a vertical list.
As you can see in the image below, you can refer to the spill range to drive another calculation.
This technique offers a lot of opportunities if you work with lists.