Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.
If you need a legend longer than your data, you’ve gone too far.
Calculating sales tax on prices is something you don't have to worry about if you use Excel. You can add a formula to the spreadsheet you use for invoices, bills of sale or quotes, and that's the end ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results