GREETINGS!
Context:
I’m attempting to create a horizontal list that dynamically shifts. The data comes from a standard table with 4 columns. My main issue is that I am unable to figure out a formula that creates a list that has 2 criteria and allows for duplicate values.
Criteria 1: Items match the searched item’s manf. #
Criteria 2: Item has been not been used.
Goal: List of all applicable expiration dates. (Some unsued items may have the same expiration date).
I am familiar with using iserror, index, small, row to create a list that allows for duplicate values but with only on condition.
I am also familiar with using index, match, countif to get a unique list with multiple conditions.
For some reason, I can’t figure out how to add one more criteria to a duplicate allowing list. Any help would be greatly appreciated.
Bookmarks