Good day, I have a purchase order column with thousands of purchase orders. each purchase order has various accounts associated with it. I would like a formula that allows me to identify any purchase order that contains Account 1250.141. Thanks for your help.
@dw700d Consider using a pivot table, set-up as in the attached file. Or perhaps your Excel version supports dynamic arrays. Then you may use UNIQUE and FILTER in combination with data validation, as demonstrated in the file as well.