假设A列中为0到9的文本数字,不按数字顺序排列,有5000个数.举例如下A1-A5000:5,4,1,1,9,7,6,5,4,1,2,1,3,3,4,8,……………5,4,1,6,7,3,0,5,4,1,8,4,9,3,0,8,5,4,1,3,0,5,2,6,5,4,1,0,8,0,2,5,4,1,7,8,7,5,9,7,0,5,4,1.与A4998A4999A50
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/06 20:08:51
![假设A列中为0到9的文本数字,不按数字顺序排列,有5000个数.举例如下A1-A5000:5,4,1,1,9,7,6,5,4,1,2,1,3,3,4,8,……………5,4,1,6,7,3,0,5,4,1,8,4,9,3,0,8,5,4,1,3,0,5,2,6,5,4,1,0,8,0,2,5,4,1,7,8,7,5,9,7,0,5,4,1.与A4998A4999A50](/uploads/image/z/8818916-68-6.jpg?t=%E5%81%87%E8%AE%BEA%E5%88%97%E4%B8%AD%E4%B8%BA0%E5%88%B09%E7%9A%84%E6%96%87%E6%9C%AC%E6%95%B0%E5%AD%97%2C%E4%B8%8D%E6%8C%89%E6%95%B0%E5%AD%97%E9%A1%BA%E5%BA%8F%E6%8E%92%E5%88%97%2C%E6%9C%895000%E4%B8%AA%E6%95%B0.%E4%B8%BE%E4%BE%8B%E5%A6%82%E4%B8%8BA1-A5000%EF%BC%9A5%2C4%2C1%2C1%2C9%2C7%2C6%2C5%2C4%2C1%2C2%2C1%2C3%2C3%2C4%2C8%2C%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A65%2C4%2C1%2C6%2C7%2C3%2C0%2C5%2C4%2C1%2C8%2C4%2C9%2C3%2C0%2C8%2C5%2C4%2C1%2C3%2C0%2C5%2C2%2C6%2C5%2C4%2C1%2C0%2C8%2C0%2C2%2C5%2C4%2C1%2C7%2C8%2C7%2C5%2C9%2C7%2C0%2C5%2C4%2C1.%E4%B8%8EA4998A4999A50)
假设A列中为0到9的文本数字,不按数字顺序排列,有5000个数.举例如下A1-A5000:5,4,1,1,9,7,6,5,4,1,2,1,3,3,4,8,……………5,4,1,6,7,3,0,5,4,1,8,4,9,3,0,8,5,4,1,3,0,5,2,6,5,4,1,0,8,0,2,5,4,1,7,8,7,5,9,7,0,5,4,1.与A4998A4999A50
假设A列中为0到9的文本数字,不按数字顺序排列,有5000个数.举例如下A1-A5000:5,4,1,1,9,7,6,5,4,1,2,1,3,3,4,8,……………5,4,1,6,7,3,0,5,4,1,8,4,9,3,0,8,5,4,1,3,0,5,2,6,5,4,1,0,8,0,2,5,4,1,7,8,7,5,9,7,0,5,4,1.与A4998A4999A5000连续相同的数据组后的下一个数,如上例5,4,1后的数据为1,2,……………6,8,3,0,7.我想让A5001=7,A5002=0,A5003=3,A5004=8,A5005=6.现在A5001输入公式=IF(OR(D1:D4998&D2:D4999&D3:D5000=D$4998&D$4999D$5000),LOOKUP(2,1/(D1:D4998&D2:D4999&D3:D5000=D$4998&D$4999D$5000),D4:D45000),"错误"),可以自动得出A5001的值.在A5002,A5003,A5004,A5005输入什么公式才可以?当A列数据发生变化时,公式仍能用.
假设A列中为0到9的文本数字,不按数字顺序排列,有5000个数.举例如下A1-A5000:5,4,1,1,9,7,6,5,4,1,2,1,3,3,4,8,……………5,4,1,6,7,3,0,5,4,1,8,4,9,3,0,8,5,4,1,3,0,5,2,6,5,4,1,0,8,0,2,5,4,1,7,8,7,5,9,7,0,5,4,1.与A4998A4999A50
在A5001输入公式:
=IF(ROW(A1)>SUM(N(D$1:D$4994&D$2:D$4995&D$3:D$4996=D$4998&D$4999&D$5000)),"",INDEX(D:D,LARGE(IF(D$1:D$4994&D$2:D$4995&D$3:D$4996=D$4998&D$4999&D$5000,ROW($4:$4997),0),ROW(A1))))
公式以CTRL+SHIFT+ENTER三键结束.
将公式向下复制.