我有一列人们给出的文字游戏答案,以及所有可能正确答案的列表 . 我正在试图弄清楚我如何能够计算出每个人的响应单元格中右边答案列表中有多少单词 .
因此,A列包含人们的响应数据,如下所示:
glare, lake, car
rag, clear, gear, lear, cake, glare, rack, keg, car, care, leak, ace
cake, lake, lark, car, rake, cage, real, ekl, rage
Leak, Rage, Gale, Kale, Rag, Lag, Large, Lack, Real, Rake, Race, Car, Care, Leg, Cage
以下是所有正确答案的列表:
grackle, calker, lacker, rackle, argle, cager, carle, clear, clerk, crake, creak, glace, glare, grace, lacer, lager, laker, large, regal, acre, ager, alec, cage, cake, calk, care, cark, carl, clag, crag, earl, egal, gale, gear, geck, kale, lace, lack, lake, lark, leak, lear, race, rack, rage, rake, rale, real, reck, ace, age, ale, arc, are, ark, car, cel, ear, elk, era, erg, gae, gal, gar, gel, kae, kea, keg, lac, lag, lar, lea, leg, lek, rag, rec, reg
所以,第一个人写了3个正确答案,所以B1应该说“3”,B2应该说“12”,B3应该说“8”(不是“9”,因为“ekl”不在正确答案列表中) , 等等 .
我假设这最好用宏而不是公式来完成,但我真的不知道从哪里开始所以任何帮助都会非常感激 . 如果解决方案是基于宏观或基于公式的,那对我来说无关紧要 . 谢谢!