Excel to googlehseets

[Phil_Waite]

HI,

I have an excel formula that I can;t get to work in google sheets. I'm looking to count the number of unique values in a column that have the same corresponding value in another column.

The formula below is in the far right column to look up unique numbers of  "Postcode" that have the same "Call Sign"

=SUM(--(LEN(UNIQUE(FILTER(C:C,D:D=D2,"")))>0))

Data looks like this below. The same formula doesn't work in sheets

Unique Id	Outlet No	Postcode	Call Sign	Outlets In District	Outlets In Call Sign	Districts in Call Sign
A1209932	1	TW11	Bravo	9	894	1
56628630	2	AB11	Alpha	10	0	1
B17361F1	4	AB21	Charlie	3	0	2
CAD0D43E	5	AB21	Charlie	3	0	2
D6C22CB7	6	AB21		3	0	4
190B0A24	9	AB24	Charlie	1	0	2
D21092CE	10	AB25		3	0	4
E32134F9	12	AB25		3	0	4
0569F693	13	AB10		7	0	4
55472842	15	AB11		10	0	4
8B23235B				0	0	4
########	18	AB25		3	0	4
435F2ED9	19	AB10		7	0	4
656CCC55	20	AB10		7	0	4

Thanks

Phil

[Giuseppe_Nugara]

HI!

In order  to count the number of unique values in a column that have the same corresponding value in another column you can use this formula in google sheets :

=ARRAYFORMULA(SUM.IF(C2:C;UNIQUE(C2:C);E2:E))

[KAM]

@Phil_Waite if the answer from @Giuseppe_Nugara doesn't work, this article might help: https://www.howtogeek.com/795235/how-to-count-unique-values-in-google-sheets/

I found out about that article from BetterCloud's Monitor newsletter: https://www.bettercloud.com/monitor/ for more information and I really like their editorial content.

HTH, KAM

[Phil_Waite]

Thank you KAM

This worked

=COUNTUNIQUEIFS(C:C,D:D,D2)