Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula to SHOW duplicated values in a field

Topic Labels: Formulas
838 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Briana_Wertalik
5 - Automation Enthusiast
5 - Automation Enthusiast

I have the following in a field:

Value 1, Value 2, Value 3, Value 4, Value 5, Value 1, Value 2

I need a formula to show me the repeated values:

Value 1, Value 2

Alternatively, I have another field with the unique values of: 

Value 1, Value 2, Value 3, Value 4, Value 5

So another option could be a formula to compare this field with the original one and output the differences?

 

1 Reply 1
Sho
11 - Venus
11 - Venus

I have an experimental Rollup Field formula.
You cannot use " < > @ , " for values.
Up to 5 types of values (more if you add more rows).

 

 

REGEX_REPLACE(
"@>"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(
ARRAYJOIN(values)&",",
REGEX_EXTRACT(ARRAYJOIN(ARRAYUNIQUE(values)),"([^,]*,?$?){1}"),"<@"& REGEX_EXTRACT(ARRAYJOIN(ARRAYUNIQUE(values)),"([^,]*,?$?){1}") & "@>",2),
REGEX_EXTRACT(ARRAYJOIN(ARRAYUNIQUE(values)),"([^,]*,?$?){2}"),"<@"& REGEX_EXTRACT(ARRAYJOIN(ARRAYUNIQUE(values)),"([^,]*,?$?){2}") & "@>",2),
REGEX_EXTRACT(ARRAYJOIN(ARRAYUNIQUE(values)),"([^,]*,?$?){3}"),"<@"& REGEX_EXTRACT(ARRAYJOIN(ARRAYUNIQUE(values)),"([^,]*,?$?){3}") & "@>",2),
REGEX_EXTRACT(ARRAYJOIN(ARRAYUNIQUE(values)),"([^,]*,?$?){4}"),"<@"& REGEX_EXTRACT(ARRAYJOIN(ARRAYUNIQUE(values)),"([^,]*,?$?){4}") & "@>",2),
REGEX_EXTRACT(ARRAYJOIN(ARRAYUNIQUE(values)),"([^,]*,?$?){5}"),"<@"& REGEX_EXTRACT(ARRAYJOIN(ARRAYUNIQUE(values)),"([^,]*,?$?){5}") & "@>",2)&"<@",
"@>[^<>@]*<@","")