Dec 10 2021 06:58 PM
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 |
Dec 10 2021 09:05 PM
@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.