I have some entries that have a long text field for example
example.com
example2.com
example2.com
Is there a way to show the total unique urls?
I have this formula
ABS(IF(LEN(SUBSTITUTE(TRIM({URL/Video Match URL}),"\n","")) > 1, LEN(SUBSTITUTE(TRIM({URL/Video Match URL}),"\n","")) - 1 , LEN(SUBSTITUTE(TRIM({URL/Video Match URL}),"\n",""))) - LEN(TRIM({URL/Video Match URL})))
But this formula only counts the total of the lines/urls. I wish to only count the unique urls.
The name of the field is: URL/Video Match URL