Daniel T Li Spreadsheets _verified_ Direct

Li rejects simple dropdown lists. Instead, he builds using INDIRECT only once (he makes an exception here with a warning). More often, he uses FILTER to create dynamic arrays:

If you want to truly master Daniel T. Li spreadsheets, unlearn these habits: daniel t li spreadsheets

The impact of Li's work on spreadsheets has been profound, with applications across various industries, including: Li rejects simple dropdown lists