Skip to content
Advertisement

How to count by unique id values that contain specific text in GoogleSpreadsheet

For this question, I understand that SQL could be used via =query("some code"), it is completely valid this way, but if a simpler way exists, better.

I want to count in GoogleSpreadsheet all the disabled accounts, but only once per account_id

In this specific case, I have 2 accounts with id 4 and 3 respectively, in total, 4 row, but I want the result of the count to be the number of accounts disabled, in this case 2

I tried unsuccessfully:

Advertisement

Answer

try this:

enter image description here

works even if A column contains a date

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement