Create Dynamic Excel Data Validation Lists Using Table Spill Ranges

Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.
Houston Chronicle

Why Won't My Spreadsheet Sort?

The power of your spreadsheet information reveals itself when you slice, dice and sort it into meaningful arrangements. Microsoft Excel enables you to experiment with what-if scenarios quickly so you ...
TechRepublic

4 ways to extract sort characters from data when they aren’t at the beginning of the value in Excel

4 ways to extract sort characters from data when they aren’t at the beginning of the value in Excel Your email has been sent Software Installation Policy Five ...
Hosted on MSN

I use these 6 Excel array formulas to crush complex calculations

Excel's basic formulas work fine for simple calculations, but they quickly become cumbersome when you're dealing with complex data analysis. You end up with nested functions that are hard to read, ...