Forum Discussion
chawkie
Jul 07, 2023Copper Contributor
Analysing a list with multiple text
Looking for some help please... I have a list similar to below where people have sorted a list in an order. I'd like to count the amount of times the word "A" comes first in all fields,...
SergeiBaklan
Jul 07, 2023Diamond Contributor
As variant
=MMULT(
TRANSPOSE(ROW(A1:A3) / ROW(A1:A3)),
--(
FILTERXML(
"<t><s>" & SUBSTITUTE(A1:A3, ";", "</s><s>") &
"</s></t>",
"//s[" & TRANSPOSE(ROW(1:4)) & "]"
) = "a"
)
)
for