EXCEL 自動編號的重算速度:Realtime－線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

Blogtrottr

Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中

EXCEL 自動編號的重算速度

Jan 15th 2015, 06:56

檔案 https://onedrive.live.com/redir?resid=EC7798CF615976D6%21274
data區-F欄為訂單自動編號
檔案預設2千筆資料，目前只新增到100筆
但運算速度越來越慢，有時還會慢到無回應
目前F欄的函數為
'=LOOKUP("z",IF({1,0},"",TEXT(B3,"yymmdd")&IF(C3=設定!$C$2,VLOOKUP(D3,設定!C:D,2,),VLOOKUP(D3,設定!F:G,2,))&IF(C3=設定!$C$2,VLOOKUP(E3,設定!I:J,2,),VLOOKUP(E3,設定!L:M,2,))&TEXT(SUMPRODUCT(N(D$3:D3&E$3:E3=D3&E3)),"000")))

懇請高手們幫我看看，有沒有其它方法可以解決或改善?
像是增加輔助欄或者還有其他函數公式之類?
只要可以達到此效果的自動編號都可以，並且可以改善運算緩慢的問題!
謝謝^^

Recommended article: Chomsky: We Are All – Fill in the Blank.
This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions