Forum Discussion
Solved
filtering multiple items
I have a list of over 5,000 Purchase order numbers. Each Purchase order can have a variety of different account codes attached to it. There are 14 account codes. I would like to Identify Purchase ord...
all four values are considered text
Thank you. The formula in D2 becomes
=AND(COUNTIF($A$2:$A$16,$A2)=1,OR(B2={"6121.219M","6231.167M","6722.99","6726.99"}))
and that in E2:
=SUM(COUNTIFS($A$2:$A$16,$A2,$B$2:$B$16,{"6121.219M","6231.167M","6722.99","6726.99"}))*COUNTIFS($A$2:$A$16,$A2,$B$2:$B$16,"<>6121.219M",$B$2:$B$16,"<>6231.167M",$B$2:$B$16,"<>6722.99",$B$2:$B$16,"<>6726.99")>0