I have a list that contains a list of 5 string values. I want to find which value is repeated most often and place that value into a single line text field
Example
List1 = Learning,Learning,Shaping,Leading,Learning
In List1 the value “Learning” appears most often, I want this value to be input into a single line text field named “Dominant_Value”
In case where ther is 2 or more items that appear the exact same time
List2 = Learning,Learning,Shaping,Leading,Shaping
In this case Both Learning and Shaping Appears twice
In this scenario I want the field “Dominant_Value to be input with the value “mixed” instead
How can I do this