excel中如将a列的数字,按要求在b列等列显示要求:尾数是3的数按从小到大在b列显示,是4的在c列,尾数是5的在d列,都按从小到大顺序显示.比如a列有,23,34,67,65,97,44,55,64,53.将23,53放在b列.34,44放在c
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/18 05:21:52
![excel中如将a列的数字,按要求在b列等列显示要求:尾数是3的数按从小到大在b列显示,是4的在c列,尾数是5的在d列,都按从小到大顺序显示.比如a列有,23,34,67,65,97,44,55,64,53.将23,53放在b列.34,44放在c](/uploads/image/z/1681846-70-6.jpg?t=excel%E4%B8%AD%E5%A6%82%E5%B0%86a%E5%88%97%E7%9A%84%E6%95%B0%E5%AD%97%2C%E6%8C%89%E8%A6%81%E6%B1%82%E5%9C%A8b%E5%88%97%E7%AD%89%E5%88%97%E6%98%BE%E7%A4%BA%E8%A6%81%E6%B1%82%EF%BC%9A%E5%B0%BE%E6%95%B0%E6%98%AF3%E7%9A%84%E6%95%B0%E6%8C%89%E4%BB%8E%E5%B0%8F%E5%88%B0%E5%A4%A7%E5%9C%A8b%E5%88%97%E6%98%BE%E7%A4%BA%2C%E6%98%AF4%E7%9A%84%E5%9C%A8c%E5%88%97%2C%E5%B0%BE%E6%95%B0%E6%98%AF5%E7%9A%84%E5%9C%A8d%E5%88%97%2C%E9%83%BD%E6%8C%89%E4%BB%8E%E5%B0%8F%E5%88%B0%E5%A4%A7%E9%A1%BA%E5%BA%8F%E6%98%BE%E7%A4%BA.%E6%AF%94%E5%A6%82a%E5%88%97%E6%9C%89%2C23%2C34%2C67%2C65%2C97%2C44%2C55%2C64%2C53.%E5%B0%8623%2C53%E6%94%BE%E5%9C%A8b%E5%88%97.34%2C44%E6%94%BE%E5%9C%A8c)
x)KHNyceMO7%>|V˳ŲgYY $|.=nTlzcF'nڱPM:@e&@e@d\)D0$y//zbSn9ٜN#cc3s3SKsSS3 iPٔ}PG@6IEd`l)сu"AL!|#llFz"qzں~7l}}|4<4tu<=B4TUh 6 H(I};g2%,PX[ >ܡOv