identify data in a seperate column

Occasional Contributor

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.

 

Purchase No

Account
11250.141
1200.57C
21250.141
2200.57C
31250.141
3200223327C
412233330.141
42003.477C
51220.141
52003.477C
61220.141
62003.477C
1 Reply

@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.

Screenshot 2021-12-11 at 06.05.01.png