0

Count duplicate data in column based on data in another column

Hello there!

I have the following tables, where Campaign column is non-repeating values, and Debug column has some repeating values. I want Activations column to count the Debug columns duplicates and match it to the Campaign column.

For example, since branded appears twice in debug, how can I show the number 2 and have it aligned with "branded" in the Campaign column? 

Ideally I'd want it to look like this:

Any tips or hints.

 

Thanks.

Kind regards,

Alex

1 comment

Please sign in to leave a comment.