軟體: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
麻煩大家了 謝謝!