在B列,B2=101,B3=010,B4=110,B5=111,B6=000,B7=111,B8=000,B9=101,B10=110,B11=011,B12=110,B13=010,B14=111,B15110,B16=111,能否用函数,求出与B16单元格相等值的单元格“行号”,并记录在D列.D1=5,D2=7,D3=14
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/11 16:28:02
![在B列,B2=101,B3=010,B4=110,B5=111,B6=000,B7=111,B8=000,B9=101,B10=110,B11=011,B12=110,B13=010,B14=111,B15110,B16=111,能否用函数,求出与B16单元格相等值的单元格“行号”,并记录在D列.D1=5,D2=7,D3=14](/uploads/image/z/1097119-55-9.jpg?t=%E5%9C%A8B%E5%88%97%2CB2%3D101%2CB3%3D010%2CB4%3D110%2CB5%3D111%2CB6%3D000%2CB7%3D111%2CB8%3D000%2CB9%3D101%2CB10%3D110%2CB11%3D011%2CB12%3D110%2CB13%3D010%2CB14%3D111%2CB15110%2CB16%3D111%2C%E8%83%BD%E5%90%A6%E7%94%A8%E5%87%BD%E6%95%B0%2C%E6%B1%82%E5%87%BA%E4%B8%8EB16%E5%8D%95%E5%85%83%E6%A0%BC%E7%9B%B8%E7%AD%89%E5%80%BC%E7%9A%84%E5%8D%95%E5%85%83%E6%A0%BC%E2%80%9C%E8%A1%8C%E5%8F%B7%E2%80%9D%2C%E5%B9%B6%E8%AE%B0%E5%BD%95%E5%9C%A8D%E5%88%97.D1%3D5%2CD2%3D7%2CD3%3D14)
xJQ%p`GG+f$X]LxL$P )B'1ӱY3s+-}7A7{kL
7H1}<;E6m̳I5MaɁ9T s1DScrE?@Zּz.[͋oq%Tj~¼Ac(4GDD@H엎N29/`Z'+KRI,N&a̅"4e%l.,"8RxEr@څVfSUS;hz"dh>խYܱMh*\9BfLJfG4x(CaT^YϘ<4sxrVnw
在B列,B2=101,B3=010,B4=110,B5=111,B6=000,B7=111,B8=000,B9=101,B10=110,B11=011,B12=110,B13=010,B14=111,B15110,B16=111,能否用函数,求出与B16单元格相等值的单元格“行号”,并记录在D列.D1=5,D2=7,D3=14
在B列,B2=101,B3=010,B4=110,B5=111,B6=000,B7=111,B8=000,B9=101,
B10=110,B11=011,B12=110,B13=010,B14=111,B15110,B16=111,能否用函数,求出与B16单元格相等值的单元格“行号”,并记录在D列.D1=5,D2=7,D3=14
在B列,B2=101,B3=010,B4=110,B5=111,B6=000,B7=111,B8=000,B9=101,B10=110,B11=011,B12=110,B13=010,B14=111,B15110,B16=111,能否用函数,求出与B16单元格相等值的单元格“行号”,并记录在D列.D1=5,D2=7,D3=14
D1输入公式:
=IF(ROW(A1)>COUNTIF(B$2:B$15,B$16),"",SMALL(IF(B$2:B$15=B$16,ROW($2:$15)),ROW(A1)))
摁 SHIFT+CTRL+回车 结束公式的输入,再将公式向下拉填充复制就可以了.