rng is a defined name range on the worksheet with each cell containing delimited strings. Although it does not necessarily have to be a 1-column list, most examples of delimited strings in a range are of this type. To convert this range to an array, use the following formula.
Define arr as =ArrayFromCDS(TEXTJOIN(“,”,,rng))
where the VBA UDF is shown below.
Function ArrayFromCDS(MyString As String)
ArrayFromCDS = Split(MyString, “,”)
So, arr is a 1-D array of all of the delimited values from each cell of the range. Then, use this formula
to return the most frequent item.