戴靜怡程式設計學習

 095教學影片 <iframe width="560" height="315" src="https://www.youtube.com/embed/lpJLWCTsKFo?controls=0" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe> 096教學影片 <iframe width="560" height="315" src="https://www.youtube.com/embed/ZDOaDmq2qmQ" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe> 097教學影片 <iframe width="560" height="315" src="https://www.youtube.com/embed/lpJLWCTsKFo" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe> ...

2021/05/17 EXCEL函數 =VLOOKUP($A2,損益表,14,FALSE)   =VLOOKUP($A13,$A$2:$F$8,F$12,)   =COLUMN(E1)  =ROW(A1)  =TRANSPOSE(F2:F5)  =HLOOKUP(B$28,橫變直,$A29,FALSE)

比較直接讀取與"資料->從檔案" 下載091單元損益表 =PERCENTRANK([基本每股盈餘（元）],[@基本每股盈餘（元）]) 百分per