Count unique occurrences, segmented by two columns

[brendanyoung]

For this problem, I have three columns: User (column A), Company (B), and Outreach type (C). I wish to count unique occurrences of the values in column B for each combination of columns A and C. '

Column A example values: person1, person2, person3
Column B example values: Acme, Walmart, Microsoft
Column C: Connected, Unconnected

I need to count how many "connected" rows person1 has, without double-counting column B. Any ideas?

[Pepe Le Mokko]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[brendanyoung]

sample workbook.xlsx

Thanks!

[Tony Valko]

Try this...

Enter this array formula** on the After sheet in cell B4:

=SUM(IF(FREQUENCY(IF(before!$A$2:$A$14=$A4,IF(before!$C$2:$C$14=B$3,MATCH(before!$B$2:$B$14,before!$B$2:$B$14,0))),ROW(before!$B$2:$B$14)-ROW(before!B$2)+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.

Copy across to C4 then down as needed.