7 Replies Latest reply: Aug 13, 2014 6:54 AM by Michael Tarallo RSS

    Load values in a column if not equal to

      I have some values(lets say red, blue, green, orange, black, yellow, (blank) ) in column A.

       

      How can I load column A with only red, blue, and yellow?

      I am able to do

      Load

      if(A<> red, A)

       

      How can I add multiple values and add the blank as well?

       

      Thank you in advance

       

      (Don't have access to "Discussion Forums")