从各行中提取关键字求和

jdjs893k

在某一列的很多行里面有出行人，同一行出行人中间有,号隔开，需要按照出行人姓名维度统计出行天数。具体需求如下，因涉及的记录行及出行人较多，求助快捷公式，谢谢



weibo.com/ttarticle/p/show?id=2309405028814399865195
weibo.com/ttarticle/p/show?id=2309405028814408515636
weibo.com/ttarticle/p/show?id=2309405028814412709911
weibo.com/ttarticle/p/show?id=2309405028814437613705
weibo.com/ttarticle/p/show?id=2309405028814437613777
weibo.com/ttarticle/p/show?id=2309405028814442070197
weibo.com/ttarticle/p/show?id=2309405028814467236282
weibo.com/ttarticle/p/show?id=2309405028814471430244
weibo.com/ttarticle/p/show?id=2309405028814471168088
weibo.com/ttarticle/p/show?id=2309405028814525956165
weibo.com/ttarticle/p/show?id=2309405028814555054415
weibo.com/ttarticle/p/show?id=2309405028814588608771
weibo.com/ttarticle/p/show?id=2309405028814626357412
weibo.com/ttarticle/p/show?id=2309405028814639202308
weibo.com/ttarticle/p/show?id=2309405028814655979650
weibo.com/ttarticle/p/show?id=2309405028814659911725
weibo.com/ttarticle/p/show?id=2309405028814668300293
weibo.com/ttarticle/p/show?id=2309405028814685339665
weibo.com/ttarticle/p/show?id=2309405028814689534096
weibo.com/ttarticle/p/show?id=2309405028814693466260
weibo.com/ttarticle/p/show?id=2309405028814718632057
weibo.com/ttarticle/p/show?id=2309405028814752448721
weibo.com/ttarticle/p/show?id=2309405028814786003293
weibo.com/ttarticle/p/show?id=2309405028814823751915
weibo.com/ttarticle/p/show?id=2309405028814865694722
weibo.com/ttarticle/p/show?id=2309405028814874083666
weibo.com/ttarticle/p/show?id=2309405028814890860651
weibo.com/ttarticle/p/show?id=2309405028814894793003
weibo.com/ttarticle/p/show?id=2309405028814907375955
weibo.com/ttarticle/p/show?id=2309405028814915764362
weibo.com/ttarticle/p/show?id=2309405028814924415206
weibo.com/ttarticle/p/show?id=2309405028814945386684
weibo.com/ttarticle/p/show?id=2309405028814945124424
weibo.com/ttarticle/p/show?id=2309405028814966358248
weibo.com/ttarticle/p/show?id=2309405028814995456054
weibo.com/ttarticle/p/show?id=2309405028815025078461
weibo.com/ttarticle/p/show?id=2309405028815272542241
weibo.com/ttarticle/p/show?id=2309405028815280931219
weibo.com/ttarticle/p/show?id=2309405028815285125140
weibo.com/ttarticle/p/show?id=2309405028815301902478
weibo.com/ttarticle/p/show?id=2309405028815314223189
weibo.com/ttarticle/p/show?id=2309405028815314485416
weibo.com/ttarticle/p/show?id=2309405028815335456816
weibo.com/ttarticle/p/show?id=2309405028815348039730
weibo.com/ttarticle/p/show?id=2309405028815348039904
weibo.com/ttarticle/p/show?id=2309405028815389982825
weibo.com/ttarticle/p/show?id=2309405028815419080765
weibo.com/ttarticle/p/show?id=2309405028815448440939
weibo.com/ttarticle/p/show?id=2309405028815494578303
weibo.com/ttarticle/p/show?id=2309405028815499034660
weibo.com/ttarticle/p/show?id=2309405028815499035061
weibo.com/ttarticle/p/show?id=2309405028815523938569
weibo.com/ttarticle/p/show?id=2309405028815528132805
weibo.com/ttarticle/p/show?id=2309405028815528132883
weibo.com/ttarticle/p/show?id=2309405028815553560823
weibo.com/ttarticle/p/show?id=2309405028815557755014
weibo.com/ttarticle/p/show?id=2309405028815557492864
weibo.com/ttarticle/p/show?id=2309405028815624601811
weibo.com/ttarticle/p/show?id=2309405028815671001365
weibo.com/ttarticle/p/show?id=2309405028815712944352
weibo.com/ttarticle/p/show?id=2309405028815759081600
weibo.com/ttarticle/p/show?id=2309405028815763013690
weibo.com/ttarticle/p/show?id=2309405028815767470461
weibo.com/ttarticle/p/show?id=2309405028815788441829
weibo.com/ttarticle/p/show?id=2309405028815792373915
weibo.com/ttarticle/p/show?id=2309405028815796830442
weibo.com/ttarticle/p/show?id=2309405028815817539795
weibo.com/ttarticle/p/show?id=2309405028815821996204
weibo.com/ttarticle/p/show?id=2309405028815826190408
weibo.com/ttarticle/p/show?id=2309405028815893037289
weibo.com/ttarticle/p/show?id=2309405028815922397252
weibo.com/ttarticle/p/show?id=2309405028815947825508
weibo.com/ttarticle/p/show?id=2309405028815989768533
weibo.com/ttarticle/p/show?id=2309405028816014671946
weibo.com/ttarticle/p/show?id=2309405028816031449133
weibo.com/ttarticle/p/show?id=2309405028816065003539
weibo.com/ttarticle/p/show?id=2309405028816065265991
weibo.com/ttarticle/p/show?id=2309405028816077848863
weibo.com/ttarticle/p/show?id=2309405028816094363809
weibo.com/ttarticle/p/show?id=2309405028816094626144
weibo.com/ttarticle/p/show?id=2309405028816119791667
weibo.com/ttarticle/p/show?id=2309405028816144957604
weibo.com/ttarticle/p/show?id=2309405028816178511974
weibo.com/ttarticle/p/show?id=2309405028816207872343
weibo.com/ttarticle/p/show?id=2309405028816258203654
weibo.com/ttarticle/p/show?id=2309405028816257941693
weibo.com/ttarticle/p/show?id=2309405028816262398138
weibo.com/ttarticle/p/show?id=2309405028816283369642
weibo.com/ttarticle/p/show?id=2309405028816291758286
weibo.com/ttarticle/p/show?id=2309405028816291758378
weibo.com/ttarticle/p/show?id=2309405028816312729641

cnmlgb9998

？？？？ 空白？文件上传

痛痛痛痛

发帖基本要求
1、问题说明，问题都说不清楚，别人怎么可能去回答正确答案！
2、结果举例，最好放图里。一是方便看帖人评估问题自己是否能解答；二是评估解答时间，一个问题也许能解答，但是要花费上半天一天的，也不会有人愿意解答的。（友情提示：问题要专一，有针对性，而不是拿一个系统性问题，方方面面的问题来问。准备吃白食？？）
3、源文件。没人愿意搭理没有源文件的帖子，除非极简单的源数据，几秒钟就能自己实现，否则不会有人花上一二十分钟录入数据，再帮你去解答。

如果没人回答，看看你的帖子哪一点有问题？？

魚。。

说好的出行人呢？