excel 如何判定数值在哪一行 筛选出特定数值A1=1,B1=100 D1=122A2=100,B2=150 D2=221A3=150,B3=265 D3=322如何判定数值在哪一行如A9=145 则D25=221回答的不是正确的,我是要在如A1=1,B1=100 D1=122A2=100,B2=150 D2=221A3=
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/07 14:57:10
![excel 如何判定数值在哪一行 筛选出特定数值A1=1,B1=100 D1=122A2=100,B2=150 D2=221A3=150,B3=265 D3=322如何判定数值在哪一行如A9=145 则D25=221回答的不是正确的,我是要在如A1=1,B1=100 D1=122A2=100,B2=150 D2=221A3=](/uploads/image/z/2760840-0-0.jpg?t=excel+%E5%A6%82%E4%BD%95%E5%88%A4%E5%AE%9A%E6%95%B0%E5%80%BC%E5%9C%A8%E5%93%AA%E4%B8%80%E8%A1%8C+%E7%AD%9B%E9%80%89%E5%87%BA%E7%89%B9%E5%AE%9A%E6%95%B0%E5%80%BCA1%3D1%2CB1%3D100+D1%3D122A2%3D100%2CB2%3D150+D2%3D221A3%3D150%2CB3%3D265+D3%3D322%E5%A6%82%E4%BD%95%E5%88%A4%E5%AE%9A%E6%95%B0%E5%80%BC%E5%9C%A8%E5%93%AA%E4%B8%80%E8%A1%8C%E5%A6%82A9%3D145+%E5%88%99D25%3D221%E5%9B%9E%E7%AD%94%E7%9A%84%E4%B8%8D%E6%98%AF%E6%AD%A3%E7%A1%AE%E7%9A%84%2C%E6%88%91%E6%98%AF%E8%A6%81%E5%9C%A8%E5%A6%82A1%3D1%2CB1%3D100+++D1%3D122A2%3D100%2CB2%3D150++D2%3D221A3%3D)
xn@_ŊTw},vPS@\DD"AHPpFmqxƶZBTwfҵ4~jϻw1}r֙
Wg;7ٖ, .l;l*ac!E 65UpM0iˊ*GE~%דt5?