j8typz 发表于 2024-10-2 14:45:22

Excel必学技巧，自定义名叫作排序3种办法，1分钟学会！


    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">工作中，对数据表格排序的时候，<span style="color: black;">倘若</span>是数字，<span style="color: black;">能够</span>对其<span style="color: black;">体积</span>进行升降序，<span style="color: black;">倘若</span>是文本，Excel默认是<span style="color: black;">按照</span>首字母拼音来进行排序的，<span style="color: black;">然则</span>经常<span style="color: black;">不可</span>满足<span style="color: black;">咱们</span>的<span style="color: black;">需要</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">例如，<span style="color: black;">咱们</span>想<span style="color: black;">按照</span>月份进行排序时，10月，11月，12月老是排在最前面。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">或</span>对岗位进行升序的时候，它<span style="color: black;">亦</span><span style="color: black;">无</span><span style="color: black;">根据</span><span style="color: black;">咱们</span>想要的职位高低进行排序。</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/4ec2f064df8e4dcd8776a00d2c701786~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727980896&amp;x-signature=OIU7K6jmdXHmFC8jVkP8yE3KIRI%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">学会今天的技巧，<span style="color: black;">容易</span>自定义进行排序，想怎么排就怎么排，有3种<span style="color: black;">办法</span>来进行自定义的排序</p>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">办法</span>一：<span style="color: black;">运用</span>高级排序</h1>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">咱们</span>以岗位等级的这个例子来进行排序，<span style="color: black;">咱们</span>选中数据区域，点击排序，<span style="color: black;">咱们</span><span style="color: black;">运用</span>自定义排序，勾选数据<span style="color: black;">包括</span>标题，<span style="color: black;">而后</span><span style="color: black;">选取</span>按岗位，自定义排序</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/5c01d9bdfec94cceb34ca6e0fdfcfe03~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727980896&amp;x-signature=%2F7xgZA%2F0WH4aZyfSbWYgEenJwhY%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">而后</span>在自定义序列里面，输入<span style="color: black;">咱们</span>想要排序的文本，点击添加</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/4cc7ad7539694cf098e19d9f93e5050b~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727980896&amp;x-signature=VTnDCiVTAlj1Wn7ERAmIqeLlKsg%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">点击完成，就能<span style="color: black;">根据</span><span style="color: black;">咱们</span>要<span style="color: black;">需要</span>进行排序了：</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/8c5b5d819e294760996cd8361febc28b~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727980896&amp;x-signature=XFyHzJvXJ3LhTHc81T%2BGXXzN7ps%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">办法</span>二：<span style="color: black;">运用</span>自定义序列</h1>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">和<span style="color: black;">办法</span>一的原理是<span style="color: black;">同样</span>的，只是<span style="color: black;">次序</span>不<span style="color: black;">同样</span>，<span style="color: black;">咱们</span><span style="color: black;">能够</span>先去自定义列表里面添加<span style="color: black;">咱们</span>想要的<span style="color: black;">次序</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/65a674cf45c94c5b8ad50f3922895148~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727980896&amp;x-signature=YwL5nt1yhHuK%2BmdWd1DTaxugHYo%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">而后</span><span style="color: black;">一样</span>的到了自定义序列的界面，从<span style="color: black;">这儿</span>进去的好处是<span style="color: black;">能够</span>从表格里面进行导入的输入，<span style="color: black;">不消</span>手动一个个编辑</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/77bd00f616ea4a2b9fd5900f17a86cc6~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727980896&amp;x-signature=t%2BZ7ctlvuibMAwN%2B1mCyU8hTdWo%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">有了这个自定义序列之后，<span style="color: black;">咱们</span>点击表格上方的升序按纽就<span style="color: black;">能够</span>直接排序，<span style="color: black;">不消</span>点进去自定义了</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/7a3712cefcca42dbabb2a88c0323123e~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727980896&amp;x-signature=d7yAGK3c0jPlR%2F%2F4H33smdHo9BM%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">办法</span>三：<span style="color: black;">运用</span>公式+辅助列</h1>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">自定义的序列是有限制的，只能输入200多个文本，<span style="color: black;">倘若</span>说<span style="color: black;">咱们</span>需要自定义排序的文本数据太多时，就<span style="color: black;">不可</span><span style="color: black;">运用</span>自定义序列，这个时候就<span style="color: black;">能够</span><span style="color: black;">运用</span>函数公式+辅助列</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">首要</span>，<span style="color: black;">咱们</span>要列出<span style="color: black;">咱们</span>排的文本序列，<span style="color: black;">而后</span>用row()函数自动标记一个序号，<span style="color: black;">亦</span><span style="color: black;">能够</span>手动标记</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/c030156628db4b8d9e0a557e86967ef9~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727980896&amp;x-signature=XZBQr0UvsUGLDzKz43E3wLSx9OQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">而后</span><span style="color: black;">咱们</span>在原数据里面，<span style="color: black;">插进</span>一个辅助列，排序，<span style="color: black;">运用</span>公式：</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">=XLOOKUP(A2,E:E,F:F)，来匹配对应的序号</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/625e8e7e6fad42e2aca53fdd625edd11~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727980896&amp;x-signature=hIgOyJXx5FHu55R6uYsGbjs53VU%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">最后只需要对排序列进行升序，就能得到想要的结果：</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/e3610a7871854cf091400cdefa913888~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727980896&amp;x-signature=v7ynPaDD8WHF0urkT3q71wy7A%2Bs%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">这个<span style="color: black;">办法</span>适用需要排序的文本<span style="color: black;">尤其</span>多的时候，<span style="color: black;">尤其</span>好用！</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">关于这3个自定义排序的<span style="color: black;">办法</span>，你学会了么？动手试试吧！</p>




qzmjef 发表于 2024-10-3 17:29:43

楼主的文章非常有意义，提升了我的知识水平。

nqkk58 发表于 2024-10-25 05:22:07

交流如星光璀璨，点亮思想夜空。
页: [1]
查看完整版本: Excel必学技巧，自定义名叫作排序3种办法，1分钟学会！