Excel:排列行以匹配另一行
我有一个数据库,其中 A 列包含一些值,然后还有 2 个附加列:B 列包含一堆值,这些值将与 A 列中的值匹配,但不按顺序排列。我还有一个包含与该特定行相关的信息的列,amnd 希望它与 B 列保持“同步”。例如:
| A | B | C |
1 3 A
2 1 F
3 2 D
4 5 R
5 4 P
我想要一种对其进行排序的方法,这样我的结果将是:
| A | B | C |
1 1 F
2 2 D
3 3 A
4 4 P
5 5 R
有没有办法要这样做吗?
如果可能的话,如果没有匹配,删除该行?
I have a database with a column A with some values, and then 2 additional columns: Column B contains a bunch values that will match the ones in column A, but are not in order. I also have a Column with information that pertains to that specific row, amnd would like it to stay in 'sync' with column B. For example:
| A | B | C |
1 3 A
2 1 F
3 2 D
4 5 R
5 4 P
I'd like a way to sort it so my result would be:
| A | B | C |
1 1 F
2 2 D
3 3 A
4 4 P
5 5 R
Is there a way to do this?
If possible, if there is no match, delete the row?
在 Excel 2007/2010 中,
只需选择其中包含“B”的单元格,然后转到顶部的“数据”选项卡,然后单击数据选项卡中间附近的“A 到 Z”按钮即可。只要 B& C 是相邻的列,它们会根据您的需要进行排序。请注意,A 列不得与其他 2 列相邻,否则您将执行上述相同的过程,但会突出显示 B 列和 C 列并执行相同的排序按钮步骤。如果出现排序警告,请单击“继续当前选择”单选按钮,然后单击“确定”。
In Excel 2007/2010,
simply select the cell with the "B" in it and go to the Data tab along the top and click on the A to Z button which is near the middle of the data tab. As long as B & C are adjacent columns, they will sort according to your needs. Please Note, Column A must not be adjacent to the other 2, otherwise you would run through the same procedure above but you would highlight columns B and C and perform the same sort button steps. If it gives you a Sort Warning, click the "Continue with the Current Selection" radio button and OK.