020-88889999
网站首页 关于我们 课程设置 新闻动态 造型团队 学员风采 教学成果 在线留言 联系我们
课程设置CURRICULUM

新闻动态

当前位置: 首页 > 新闻动态

财务自动计算软件如何提取公式,财务自动计算软件如何提取公式数据

发布时间:2023-07-02 20:31:43 点击量:

EXCEL公式如何提取数据

工作中遇到不同文段内容提取规律不一样,所以要根据内容寻找规律。凯时kb88最新app

首先,把本问题的句段分拆三部分,如下图:第二,拆分字段一中,要提取“针织”或“梭织”,用到经典函数LOOKUP(,-FIND()) ,函数公式为:=LOOKUP(,-FIND({"
针织"
,"
梭织"
},B2),{"
针织"
,"
梭织"
})第三,拆分字段二中,提取"
女装"
,"
女成人"
,"
男成人"
,"
男装"
,"
女童"
,"
男童"
且改为"
女式"
,"
女式"
,"
男式"
,"
男式"
,"
女童"
,"
男童"
函数公式为=LOOKUP(,-FIND({"
女装"
,"
女成人"
,"
男成人"
,"
男装"
,"
女童"
,"
男童"
},B2),{"
女式"
,"
女式"
,"
男式"
,"
男式"
,"
女童"
,"
男童"
})第四,拆分字段三中,要提取"
女装"
/
"
女成人"
/
"
男成人"
/
"
男装"
/
"
女童"
/
"
男童"
后面所有内容,函数公式是=RIGHT(B2,LEN(B2)-FIND(LOOKUP(,-FIND({"
女装"
,"
女成人"
,"
男成人"
,"
男装"
,"
女童"
,"
男童"
},B2),{"
女装"
,"
女成人"
,"
男成人"
,"
男装"
,"
女童"
,"
男童"
}),B2)-LEN(LOOKUP(,-FIND({"
女装"
,"
女成人"
,"
男成人"
,"
男装"
,"
女童"
,"
男童"
},B2),{"
女装"
,"
女成人"
,"
男成人"
,"
男装"
,"
女童"
,"
男童"
}))+1)最后,最终提取的结果就是用连接符& 和“|”连接起来就可以。

最终函数公式是=LOOKUP(,-FIND({"
针织"
,"
梭织"
},B2),{"
针织"
,"
梭织"
})&"
|"
&LOOKUP(,-FIND({"
女装"
,"
女成人"
,"
男成人"
,"
男装"
,"
女童"
,"
男童"
},B2),{"
女式"
,"
女式"
,"
男式"
,"
男式"
,"
女童"
,"
男童"
})&"
|"
&RIGHT(B2,LEN(B2)-FIND(LOOKUP(,-FIND({"
女装"
,"
女成人"
,"
男成人"
,"
男装"
,"
女童"
,"
男童"
},B2),{"
女装"
,"
女成人"
,"
男成人"
,"
男装"
,"
女童"
,"
男童"
}),B2)-LEN(LOOKUP(,-FIND({"
女装"
,"
女成人"
,"
男成人"
,"
男装"
,"
女童"
,"
男童"
},B2),{"
女装"
,"
女成人"
,"
男成人"
,"
男装"
,"
女童"
,"
男童"
}))+1)【说明:】公式内容很多,采用这种运算公式的作用避免句段内容有变,如“棉制针织女装工装长裤”变为“网红棉制针织女装工装长裤”,公式结果也不会变;
再例如除了“针织”和“梭织”,之后增加“机织”类别,只要把公式中LOOKUP(,-FIND({"
针织"
,"
梭织"
},B2),{"
针织"
,"
梭织"
})改为LOOKUP(,-FIND({"
针织"
,"
梭织"
,"
机织"
},B2),{"
针织"
,"
梭织"
,"
机织"
})就可以, 其它也是容易改动。

在EXCEL中,如何正确通过公式提取数据

财务自动计算软件如何提取公式,财务自动计算软件如何提取公式数据
Copyright © 2012-2023 emc易倍全站官网 版权所有 非商用版本 电话:020-88889999 手机:13988889999  ICP备案编号:粤ICP备8888888号