I've got a pivot table where I'm trying to count items. Basically I have a vlookup that's working fine, and I compare and get either a 1 or a 0 for the item in both fields.
However, if the item is not in the VLOOKUP I want to throw it out of the pivot table for counting purposes. Is it possible to do this? Right now I'm using an ISNA with an IF and returning "X" if it can't be found in the vlookup.
However, if the item is not in the VLOOKUP I want to throw it out of the pivot table for counting purposes. Is it possible to do this? Right now I'm using an ISNA with an IF and returning "X" if it can't be found in the vlookup.
