試試看FileSystemObject sub find_new_excel() dim oFso as object, oFolder as obje...
在VBE裡面按Ctrl+G,打開即時執行視窗輸入 Range("A3")=Range("A63") AND Range(...
這好像是笛卡爾乘積 試試看 SELECT DISTINCT a.item, b.producer, c.order_date FROM (SELECT...
用VBA Sub find_cha() Dim myRng As Range, allRng As Range, i As Long Dim f...
| |A|B||----:|----:||1|actual time||rounded time||2|23:04:41|=TIME(HOUR(A2),IF(M...
試試看,我覺得應該可以快很多。 Sub 效率總表G欄空白填上資料() Dim i as long, j As long dim a(2 to 3...
Rnd會傳回[0, 1)之間的亂數因此,我猜fix(Rnd*10) will return [0,10)的整數亂數2 * (Fix(Rnd * 5) + 1)...
用Index函數搭配Match函數即可G6寫下=INDEX(J3:N6,MATCH($E6,$I$3:$I$6,0),MATCH($F6,$J$2:$N$2,-...