I had a colleague ask me yesterday if it was possible to set an auto-filter to display columns based on the text of formulas in the cells instead of their calculated results.
For example: if I had formulas
=D3*5, I'd want to filter based on the
*5 parts of the formulas.
Is this possible? From the choices in the UI, it seems that my colleague may need to use VBA to solve the problem.