Excel如何给数据排序又不影响数据显示顺序呢?

Excel如何给数据排序又不影响数据显示顺序呢?

回复
  • 唐境璘用户
    [[{"txt": "\u5927\u5bb6\u5728\u4f7f\u7528 excel\u65f6\uff0c\u6709\u65f6\u5019\uff0c\u7ed9\u6570\u636e\u6392\u5e8f\u53c8\u4e0d\u5f71\u54cd\u6570\u636e\u663e\u793a\u987a\u5e8f\uff0c\u8fd9\u65f6\u5019\u5c31\u9700\u8981\u7528Excel\u7684RANK.EQ\u51fd\u6570\u4e86\uff0c\u5982\u4f55\u505a\u5230\u5462\uff1f\u4e00\u8d77\u6765\u770b\u770b\u5427~"}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "\u8054\u60f3\u7b14\u8bb0\u672c\u7535\u8111"}, {"txt": "EXCEL"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u7b2c\u4e00\u6b65\uff0c\u6253\u5f00\u8868\u683c\u00a0"}, {"img": ["https://exp-picture.cdn.bcebos.com/32a127723d03bbeaf6ccc8faea43d7d44931549d.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7b2c\u4e8c\u6b65\uff0c\u9009\u4e2dD3\u5355\u5143\u683c"}, {"img": ["https://exp-picture.cdn.bcebos.com/979906196120a7cd4c25034089b375d7987bdc9d.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7b2c\u4e09\u6b65\uff0c\u70b9\u51fb\u83dc\u5355\u680f\u201c\u516c\u5f0f\u201d->\u201c\u63d2\u5165\u51fd\u6570\u201d"}, {"img": ["https://exp-picture.cdn.bcebos.com/51f9aa3ea8db574a7d796b2ea7f7dfb2dd1917e2.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7b2c\u56db\u6b65\uff0c\u8f93\u5165\u201cRANK.EQ\u201d"}, {"img": ["https://exp-picture.cdn.bcebos.com/65ba880b31210561b6e8ad5b08aee8d7582a6ae2.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7b2c\u4e94\u6b65\uff0c\u5728\u201c\u6570\u503c\u201d\u5904\u8f93\u5165\u201cC3\u201d\uff0c\u201c\u5f15\u7528\u5904\u201d\u8f93\u5165\u201cC3\uff1aC11\u201d\uff0c\u201c\u6392\u4f4d\u65b9\u5f0f\u201d\u8f93\u5165\u201c0\u201d\uff0c\u5347\u5e8f\u6392\u5e8f"}, {"img": ["https://exp-picture.cdn.bcebos.com/7c84d1672b5fd5467dda40a67fd0b503c9d224e3.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7b2c\u516d\u6b65\uff0c\u70b9\u51fb\u201c\u786e\u8ba4\u201d\uff0c\u5373\u53ef\u770b\u5230\u7b2c\u4e00\u884c\u6570\u636e\u6392\u540d\u7b2c\u201c9\u201d"}, {"img": ["https://exp-picture.cdn.bcebos.com/e996472ae3efe078ad7d2704b96c576698cf65e3.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7b2c\u4e03\u6b65\uff0c\u9f20\u6807\u653e\u5230\u5355\u5143\u683c\u53f3\u4e0b\u65b9\uff0c\u663e\u793a\u201c+\u201d\u53f7\u540e\uff0c\u5f80\u4e0b\u62c9\uff0c\u65e2\u53ef\u4ee5\u5f97\u51fa\u5168\u90e8\u7684\u6392\u540d\u5566"}, {"img": ["https://exp-picture.cdn.bcebos.com/0fb94656d53da8248ba43460306651598440cbe3.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7b2c\u516b\u6b65\uff0c\u5b8c\u6210\u5566"}], [{"txt": ["\u6ce8\u610f\u4e8b\u9879"]}, {"txt": "\u5982\u6709\u6240\u5f97\uff0c\u8bf7\u70b9\u8d5e\u5566\uff0c\u8c22\u8c22~"}, {"txt": "\u5982\u6709\u7591\u95ee\uff0c\u6b22\u8fce\u7559\u8a00\u54df~"}]]
    2024-11-24
    1楼
    回复

参与评论

游客评论不支持回复他人评论内容,如需回复他人评论内容请