Help with sumproduct or similar type of function

J

jasondebolt

I am interested in finding a function that will count the number of
unique combinations a in two columns (columns A& B). For example:

Column A Column B Column C Column D
ABC 03/2007 =A1&B1 =SUMPRODUCT((1/
COUNTIF(C1:C5,C1:C5&"")))
BCA 03/2007 =A2&B2
CAB 07/2007 =A3&B3
ACB 07/2007 =A4&B4
ABC 03/2007 =A5&B5

In the case above, there are 4 unique combinations in columns A and B
(ABC 03/2007, BCA 03/2007, CAB 07/2007, ACB 07/2007). I don't count
the second instance of ABC 03/2007 becuase it is already in the first
row.

Is there a cleaner way of doing this? I've tried using sumproduct, but
I can't seem to get it to work the way I want it to. Does anyone know
how this can be done?

There are only four possible strings in column A (ABC, BCA, CAB, ACB)

Thanks!
Jason
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top