Counting unique words within cell and across column

[Kvitekvist]

Hello,

I am doing web analytics for a newspaper and I am trying to find a smart way to count unique users (cookies) per url in a dashboard. The tricky part is that I cannot summarizre and aggregated count of users per url to get the website's total unique users (because one user may visit more than one url).

So what I would like to do is to concatenate all cookies that visited an url into one cell, then i would like to count all the unique "cookies" based on whatever i have selected. So that if i filter out a section, a url or just a date, then I would be able to count the number of unique cookies.

Is this possible in the way i imagine it, or in any other way?

[Anonymous · Accepted solution]

Hi @Kvitekvist,

Can you please share some sample data for analysis?

In addition, you can also take a look at below link who shared the fast words count function:

Fast words count function

Regards,

Xiaoxin Sheng