[算表] excel 順序篩選問題
軟體: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
→
05/22 22:48, , 1F
05/22 22:48, 1F
→
05/22 22:49, , 2F
05/22 22:49, 2F
→
05/23 09:33, , 3F
05/23 09:33, 3F