If I have a table as noted below with the following assumptions:
- this table will likely grow
- the 'Include' column data will change based on external criteria/formulas, so the 'Include' column will not be sorted.
- Macros aren't an option as this sheet needs to be macro free.
A B C 1 Item Calories Include 2 Orange 80 Yes 3 Apple 80 Yes 4 Banana 100 No 5 Grapes 50 Yes 6 Bread 40 No 7 Butter 200 Yes
How do I build a formula that I can place in a data validation drop down to only include 'Item's that have Yes indicated in the 'Include' column?
I've been researching this and found answers if the 'Include' column was sorted via offset, but I haven't found any to sift through when unsorted. I feel like there is a simple answer to this that I am missing. Here is the sheet --> ExampleSheet.xlsx
Thanks,
dreamthrum
Bookmarks