→ soyoso:用函數match試試 05/22 22:48
→ handsome1:感激不盡 05/23 09:33
軟體: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
麻煩大家了 謝謝!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 203.219.65.37
※ 文章網址: http://www.ptt.cc/bbs/Office/M.1400763831.A.0FD.html