Forum Discussion

dw700d's avatar
dw700d
Copper Contributor
Aug 18, 2021
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...
excel
  • dw700d's avatar
    dw700d
    Copper Contributor
    Aug 19, 2021
    Thank you Hans this helps a great deal. The accounts codes are actually 6121.219M, 6231.167M ,6722.99,6726.99. I am experiencing challenges trying to replicate your formula for type 2. Are you able to rewrite the formula for me with the account codes below
    6121.219M
    6231.167M
    6722.99
    6726.99

    Thank you for your help

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Aug 19, 2021

      dw700d 

      Are the latter two text values or number values?

      • dw700d's avatar
        dw700d
        Copper Contributor
        Aug 19, 2021
        all four values are considered text

Resources