欢迎您来到CFG全球,投资有风险,选择需谨慎!
当前位置 : CFG全球 > 理财社区问答 > 详情
?
请教高手一个EXCEL的统计公式.请金斧子专家帮下忙
2018.10.27 15:39:26· 阳阳阳锋 浏览22次
1条回答
1F
=LOOKUP(TEXT(SUM(IF((C4:F4-B4:E4)<>1,0,1)*10^(5-COLUMN(A1:D1)))/10,"0000"),{"0000","0001","0010","0011","0100","0110","0111","1000","1001","1011","1100","1101","1110","1111"},{"","1","1","1","1","1","1","1","2","2","1","2","1","1"})输入完按shift+ctrl+回车
2018.10.27 17:52:09 · 韦经理
0