I need to count the number of unique values that appear in column A but not column B. There are blank cells to contend with and there are values in column B that do not appear in column A. Any ideas?
I need to count the number of unique values that appear in column A but not column B. There are blank cells to contend with and there are values in column B that do not appear in column A. Any ideas?
Post some sample data and tell us what result you expect.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Sample Data:
Sample Data.jpg
The result should be 3. The highlighted values do not appear in column B and there are 3 unique values in the set.
Try this array formula**:
=SUM(IF(FREQUENCY(IF(ISNA(MATCH(A1:A21,B1:B21,0)),IF(A1:A21<>"",MATCH(A1:A21,A1:A21,0))),ROW(A1:A21)-ROW(A1)+1),1))
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks