因为之前的评语关键字全部为2位,所以简单一些,如果出现长度不一致的情况,稍微麻烦一些,因为你排在条件里面的前面的关键字可能会出现在最后,并且长度不一致。下面的公式已经修修改过。评语长度可以不一致,出现的顺序可以和条件中的顺序不一致。
原理是先按照原先关键字描述中的所有字节进行搜索,这时候即使找到了也不能确认出现的先后顺序,只是临时截取2位作为第二次的搜索条件,再将关键字描述作为第二次的搜索基准用MATCH将第一次截取的2位字符加通配符在关键字描述中进行第二次模糊搜索,找到了就把所有长度的描述提取出来 (我都不知道我在说什么了,,,,希望你能看明白)
在你的新文件的E2复制下列函数,数组执行后向右向下复制
E2=IFERROR(INDEX({"环境好","氛围好","气氛好","干净","整洁","舒适","安静","宽敞","明亮","服务好","态度好","位置舒适","试衣间舒适","友好","细心","耐心","礼貌","放松","平静","积极","热情","激情","有责任心","微笑真诚","不出风头","声音温柔","制服干净","充满能量","印象好","满足我的需求","了解我的需求"},MATCH(MID($D2,SMALL(IF(ISERROR(FIND({"环境好","氛围好","气氛好","干净","整洁","舒适","安静","宽敞","明亮","服务好","态度好","位置舒适","试衣间舒适","友好","细心","耐心","礼貌","放松","平静","积极","热情","激情","有责任心","微笑真诚","不出风头","声音温柔","制服干净","充满能量","印象好","满足我的需求","了解我的需求"},$D2)),"/",FIND({"环境好","氛围好","气氛好","干净","整洁","舒适","安静","宽敞","明亮","服务好","态度好","位置舒适","试衣间舒适","友好","细心","耐心","礼貌","放松","平静","积极","热情","激情","有责任心","微笑真诚","不出风头","声音温柔","制服干净","充满能量","印象好","满足我的需求","了解我的需求"},$D2)),COLUMN(A1)),2)&"*",{"环境好","氛围好","气氛好","干净","整洁","舒适","安静","宽敞","明亮","服务好","态度好","位置舒适","试衣间舒适","友好","细心","耐心","礼貌","放松","平静","积极","热情","激情","有责任心","微笑真诚","不出风头","声音温柔","制服干净","充满能量","印象好","满足我的需求","了解我的需求"},)),"")
|