|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
这是一个双色格的问题,我想在BN:CA共14个单元格里提取前面的数字自动生成为500W缩水条件格式,请会的朋友帮我修改下公式,以下这公式是在当BN:CA单元格出现14个数字才能实现,我想把它改为当BN:CA单元格出现14或小于14个数字时能自动实现
=IF(A31="","",TEXT(SMALL(BN31:CA31,1),"00")&","&TEXT(SMALL(BN31:CA31,2),"00")&","&TEXT(SMALL(BN31:CA31,3),"00")&","&TEXT(SMALL(BN31:CA31,4),"00")&","&TEXT(SMALL(BN31:CA31,5),"00")&","&TEXT(SMALL(BN31:CA31,6),"00")&","&TEXT(SMALL(BN31:CA31,7),"00")&","&TEXT(SMALL(BN31:CA31,8),"00")&","&TEXT(SMALL(BN31:CA31,9),"00")&","&TEXT(SMALL(BN31:CA31,10),"00")&","&TEXT(SMALL(BN31:CA31,11),"00")&","&TEXT(SMALL(BN31:CA31,12),"00")&","&TEXT(SMALL(BN31:CA31,13),"00")&","&TEXT(SMALL(BN31:CA31,14),"00")&"/1~2~3~4")
请会的朋友帮我改下,谢谢
|
|