獲取目前選取的儲存格位置: =ADDRESS(ROW(),COLUMN()) or =CELL("address")
儲存格位移: =OFFSET(reference, rows, cols, [height], [width])
儲存格位移的值: =OFFSET(INDIRECT(CELL("address")),0,-1)
判斷值: =IF(OFFSET(INDIRECT(CELL("address")),0,-1) = "??", ?, ?)
資料驗證: =COUNTIF(A:A,A1)=1
小寫大寫大小寫: LOWER、UPPER、PROPER
資料驗證範例:
=IF(OFFSET(INDIRECT(CELL("address")),0,-1) = "??", COUNTIF(B:B,B1)=1,)
