"例题描述和简单分析有 Excel 文件，数据如下所示： A B 1 Parent Column Modifier (Column) 2 Jack lives in the village R .."

jiangzhucao 北京
乾学院 1061 号会员
2 回帖 • 82 浏览 • 3 周前

Excel 根据包含的关键词将指定列按关键词指定顺序排列

Excel处理

例题描述和简单分析

有 Excel 文件，数据如下所示：

	A	B
1	Parent Column	Modifier (Column)
2	Jack lives in the village	Rose
3	As mentioned by jack	Village
4	Rose already spoke to jack about last night	Jack
5	Rose left the village
6	rose was their yesterday

A列（Parent Column）需要根据包含的关键词按照关键单词列表 (Modifier (Column)) 的顺序排序，结果如下：

	A	B
1	Parent Column	Modifier (Column)
2	Rose already spoke to jack about last night	Rose
3	Rose left the village	Village
4	rose was their yesterday	Jack
5	Jack lives in the village
6	As mentioned by jack