excel初学者提问:如何把A列中的特定数字,后面的一个数字引用要B列中.举例A列中,1,3,7,5,7,2,5,3,9,7,9,5,5,2,7,4,7,2.假设特定数字是7,我想把7出现后的5,2,9,5,4,2等等这写数字单独列到B列中
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/06 13:53:34
![excel初学者提问:如何把A列中的特定数字,后面的一个数字引用要B列中.举例A列中,1,3,7,5,7,2,5,3,9,7,9,5,5,2,7,4,7,2.假设特定数字是7,我想把7出现后的5,2,9,5,4,2等等这写数字单独列到B列中](/uploads/image/z/14395946-50-6.jpg?t=excel%E5%88%9D%E5%AD%A6%E8%80%85%E6%8F%90%E9%97%AE%EF%BC%9A%E5%A6%82%E4%BD%95%E6%8A%8AA%E5%88%97%E4%B8%AD%E7%9A%84%E7%89%B9%E5%AE%9A%E6%95%B0%E5%AD%97%2C%E5%90%8E%E9%9D%A2%E7%9A%84%E4%B8%80%E4%B8%AA%E6%95%B0%E5%AD%97%E5%BC%95%E7%94%A8%E8%A6%81B%E5%88%97%E4%B8%AD.%E4%B8%BE%E4%BE%8BA%E5%88%97%E4%B8%AD%2C1%2C3%2C7%2C5%2C7%2C2%2C5%2C3%2C9%2C7%2C9%2C5%2C5%2C2%2C7%2C4%2C7%2C2.%E5%81%87%E8%AE%BE%E7%89%B9%E5%AE%9A%E6%95%B0%E5%AD%97%E6%98%AF7%2C%E6%88%91%E6%83%B3%E6%8A%8A7%E5%87%BA%E7%8E%B0%E5%90%8E%E7%9A%845%2C2%2C9%2C5%2C4%2C2%E7%AD%89%E7%AD%89%E8%BF%99%E5%86%99%E6%95%B0%E5%AD%97%E5%8D%95%E7%8B%AC%E5%88%97%E5%88%B0B%E5%88%97%E4%B8%AD)
xRKAWD":="犢 B25~eYЃE pԿz=.3}ٹ%LRc ^~4Xް^|gT2+%OX-|
+{銢Vyq|cVQe6fmFK= Y^'ރ]mC{xo>"W#xv
J~=SL6/2w'8[eJGC-*8`$`L`ox˻(Hdbh`01jt
GiٴAǦAn&