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:
: Always verify you are using the version that matches the current governing code (e.g., ASCE 7-10 vs. ASCE 7-22) for your project. daniel t li spreadsheets
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:
: Always verify you are using the version that matches the current governing code (e.g., ASCE 7-10 vs. ASCE 7-22) for your project.