Learning Note

 [Format] Mega, Kilo https://web.ntpu.edu.tw/~tzung/teaching/ppts/data-process97b/format.pdf https://blog.xuite.net/andrew2/mrw/301348478 select and right click-> 儲存格格式 -> 自訂-> #,##0.0,,"M" or #,##0.0,"K" [matrix scale]  https://www.youtube.com/watch?v=YLKZs9RVhhc select 3X6 empty target cells -> press "=1e-6*" & click and drag the 3X6 source cells -> press "ctrl+shift+enter" [find multi match and list] ref. https://www.youtube.com/watch?v=5cBUIa31AiA&t=12s&ab_channel=LeilaGharani template: https://docs.google.com/spreadsheets/d/1j3cpSFfdhDv8uIUD57yzgvGeoucEjT0x/edit?usp=share_link&ouid=111335164748055427663&rtpof=true&sd=true [highlight the max/min of a column/row] Ref. https://www.youtube.com/watch?v=NcABZ8zC1DI create rule -> according to equation, and fill in  =C5=MAX(C$5:C$103)

[ visio symbol RAZAVI] https://drive.google.com/file/d/14dBNkA-Iyxd8MUlOAge8IUaWoHGQC9BC/view?usp=sharing

 [bug] corner disorder read the same file 'runObj' waveview2016.06-sp1 vs. VIVE617   The corner list order is quite different. VIVA is correct, but viewview. Feel sorry 

 [find match and index] ref. https://www.get-digital-help.com/index-match-multiple-results/ Target: find the matched number in column B and return the index content in column A with the key in D1, the result is show in column F Step: 1.  in F1 fill in the content =INDEX($A$1:$A$11, SMALL(IF(ISNUMBER(MATCH($B$1:$B$11, $D$1, 0)), MATCH(ROW($A$1:$A$11), ROW($A$1:$A$11)), ""), ROWS($A$1:A1))) 2. press 'ctrl+shift+enter' for array mode 3. pull down + symbol and extend Col F [histogram] ref. https://trumpexcel.com/histogram-in-excel/ 1. select result zone, input "frequency(data array, bin array)" 2. ctrl+shift+enter