excel - 基于数值评估列表(逗号分隔)形成 vlookup
问题描述
两个数据集,再复杂不过了
首先,在许多列中,有一个以逗号分隔的关键字,即:
Id ---- PLAYER -- KEYWORDS
1 ---- Jonh ---- futball, waterpolo , tennis
2 ---- Anna ---- soccer, swiming, running
3 ---- Marc ---- runnign, waterpolo
4 ---- Peter --- running
和一个“思考”表,其中包含所有关键字的数值
SPORT-- USE_BALL -- IN_WATER
futball --- 1 --------- 0
waterpolo - 1 --------- 1
tennis ---- 1 --------- 0
swiming --- 0 --------- 1
running --- 0 --------- 0
结果,我希望你有一张桌子,上面有这个特征的“总和”,又名:
Id ---- PLAYER -- PLAY_WITH_BALL --- PLAY_IN_WATER ---- KEYWORDS
1 ---- Jonh ----------- 3 ---------------- 1 --------- futball, waterpolo , tennis
2 ---- Anna ----------- 1 ---------------- 1 --------- soccer, swiming, running
3 ---- Marc ----------- 1 ---------------- 1 --------- runnign, waterpolo
4 ---- Peter ---------- 0 ---------------- 0 --------- running
有什么办法?最好没有宏