e**p 发帖数: 4259 | 2 刚刚自学学会用excel pivot table,但复杂一些功能不会,比如说我建立一个look-up
table,大概是这样的
COUNT Label
AA AUSTRIA Austria
AA BELGIUM Belgium
AA BULGARIA Bulgaria
AA CZECH Czech
AA DENMARK Denmark
AA FINLAND Finland
AA FRANCE France
.....
.....
我要跟另外一个table 联系起来
CTRY AREA UNITS
AA AUSTRALIA ASIA/AFRICA/AUST/ME 31,566
AA AUSTRIA WESTRN EUROPE/CANADA 28,046
AA BELGIUM SA WESTRN EUROPE/CANADA 72,138
AA CANADA WESTRN EUROP... 阅读全帖 |
|