I went on a ramble about making all the possible combos of a, b, and c in a reference table and then using filter based on cell value to spit out the answer.
that's how much i dislike drop down menus.
you could still use if and statements but type them into cells that the statements reference rather than a drop down.
that's again how much i hate drop down filters.
I went on a ramble about making all the possible combos of a, b, and c in a reference table and then using filter based on cell value to spit out the answer.
that's how much i dislike drop down menus.
you could still use if and statements but type them into cells that the statements reference rather than a drop down.
that's again how much i hate drop down filters.