Hi there. I have a very large database where many cells contain multiple values, e.g. "NA, EALA, APAC" but in filter and calculation i need to have "NA" "EALA" and "APAC" as separate items, and any cell containing "NA", like "NA, EALA" or "NA, APAC", will be considered in calculation for "NA". I was wondering if this is possible, and if yes, how to realize it. Thanks a lot.
[new added] for the filter, we have the original data as follows (the fourth row has multiple values)