Count unique values (two columns of data)
I need to count the X's in column B only if the values in Column A are unique.
The example below would result in a count of 2 (one X for 5262, and one X for 6520)
I tried several formulas (sumproduct, countifs) but can't get the correct answer.
This formula has to be entered as an array
with the formula edited press CTRL+SHIFT+ENTER