identify data in a seperate column

[dw700d]

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
1	1250.141
1	200.57C
2	1250.141
2	200.57C
3	1250.141
3	200223327C
4	12233330.141
4	2003.477C
5	1220.141
5	2003.477C
6	1220.141
6	2003.477C

[#2]

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