软件:office
版本:2010
表一
Preference Weighting
1st Pref 1
2nd Pref 2
3rd Pref 3
4th Pref 4
5th Pref 5
6th Pref 6
表二
Given Name 1st Pref 2nd Pref 3rd Pref
Ina 2014/6/6 2014/6/7 2014/6/5
Eufemia 2014/6/7 2014/6/6 2014/6/5
Robena 2014/6/6 2014/6/5 2014/6/7
表三
Given Name 05/06/2014 06/06/2014 07/06/2014
Ina 3 1 2
Eufemia
Robena
请问表三要怎么按照日期 去筛选出那个人喜好的优先级
譬如说表三的Ina 就是3-1-2
麻烦大家了 谢谢!