I need help creating a formula in excel within a pivot Table.
For example, I am analyzing Column A, B and C. each of the columns contain Items 1, 2, 3 and so on.
I need a formula for my a pivot table in which I state that all items that were already listed in Column A and are also in Column B should not be included. I only need to list only the items that are significant to just Column B itself--not including the same ones listed in both columns A and B- Hope that makes sense. PLEASE HELP.