EXCEL如何直接顯示每貨號的後四碼串在一起 - 工作
By Madame
at 2011-04-01T00:00
at 2011-04-01T00:00
Table of Contents
欄位--------A---------B--------C---1----------貨號-------數量-----2-----110225297-----1-------3-----110227460-----1-------4-----110227450-----2-------5-----110222218-----1-------需顯示成5297*1+7460*1+7450*2+2218*1欄位--------A---------B--------C---1----------貨號-------數量-----2-----110221197-----1-------3-----110227460-----1-------4-----110225840-----2-------5-----110222218-----1-------6-----110223312-----1-------需顯示成1197*1+7460*1+5840*2+2218*1+3312*1有什麼公式可直接顯示每貨號的後四碼每次的品項個數會不同有時五個有時二個有時十個..
Tags:
工作
All Comments
By Frederica
at 2011-04-02T07:33
at 2011-04-02T07:33
By Gilbert
at 2011-04-03T02:46
at 2011-04-03T02:46
By Charlie
at 2011-04-03T05:15
at 2011-04-03T05:15
By Isabella
at 2011-04-02T17:57
at 2011-04-02T17:57
Related Posts
全家工作方面問題
By Isabella
at 2011-03-31T00:00
at 2011-03-31T00:00
每天超時工作快受不了
By Donna
at 2011-03-31T00:00
at 2011-03-31T00:00
7-11工作心理調適與薪水問題
By Hedda
at 2011-03-31T00:00
at 2011-03-31T00:00
入獄服刑.........如何分期罰金
By Anonymous
at 2011-03-31T00:00
at 2011-03-31T00:00
關於上司對我的看法(解牌)
By Valerie
at 2011-03-31T00:00
at 2011-03-31T00:00