吳睿捷使用EXCEL:MATCH,INDEX函數
最大值 位置 最佳關鍵點 1.138701 28 2.70% =MAX(N2:AR2) =MATCH(AS2,$N2:$AR2,0) =INDEX($N$1:$AR$1,$AT2) 0.528531 1 0.00% 10.315605 14 1.30% 3.640566 30 2.90%
吳睿捷VBA雙迴圈Loop與JavaScript迴圈
輸出 Excel學習 Option Explicit '必須宣告所有變數variables Dim i, j As Integer '宣告dimension i, j 是整數integer Public Sub RayWu() Cells(1, 1).Value = "RayWu xxx" Cells(1, 1).Font.Size = 20 Cells(1, 1).Interior.Color = RGB(128, 0, 0) Cells(1, 1).Font.Color = RGB(255, 255, 255) End Sub Public Sub RayWu迴圈() For i = 2 To 10 For j = 1 To 6 Cells(i, j).Value = (2010 + i) & "年" Next Next End Sub
excel不清楚.https://takmingfinanc.blogspot.com/2024/03/excelmatchindex.html
回覆刪除