Make Excel evaluate your data for you.
Logic statements in Microsoft Excel allow you to test the contents of cells to see if they meet your criteria. For example, if a spreadsheet lists sales figures, you can use Excel logic statements to ...
I traded the static results of Flash Fill for dynamic formulas that update automatically.