Excel
[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)