Sorting a range by the order of another list in Excel

I have two tables, like this: **Table 1**
  A
1 FirstPhase
2 SecondPhase
3 ThirdPhase
4 FourthPhase
**Table 2**
  A     B
1 Item1 FirstPhase
2 Item4 FourthPhase
3 Item2 SecondPhase
4 Item3 ThirdPhase
The result I want to achieve after sorting is:
  A     B
1 Item1 FirstPhase
2 Item2 SecondPhase
3 Item3 ThirdPhase
4 Item4 FourthPhase
How can I sort the second table by column `B` according to the order of column `A` in the first table?
You shouldn't have set this to 'Community Wiki', you probably would have got more input. I'll see what I can figure out.

以上就是Sorting a range by the order of another list in Excel的详细内容,更多请关注web前端其它相关文章!

赞(0) 打赏
未经允许不得转载:web前端首页 » excel

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

前端开发相关广告投放 更专业 更精准

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏