excel B欄最的值

=OFFSET(B1,COUNTA(B:B)-1,0)

自動套表,表名dis1,

名稱管理員

data_bbb

=OFFSET('dis1'!$B$2,0,0,COUNTA('dis1'!$B:$B)-1,1)

data_eee

=OFFSET('dis1'!$E$2,0,0,COUNTA('dis1'!$E:$E)-1,1)

data_ggg

=OFFSET('dis1'!$G$2,0,0,COUNTA('dis1'!$G:$G)-1,1)

繪表

=SERIES('dis1'!$E$1,'dis1'!data_bbb,'dis1'!data_eee,1)

=SERIES('dis1'!$G$1,'dis1'!data_bbb,'dis1'!data_ggg,2)

//---

讀入txt

計算interval

拷貝item名

欄寬9

讀取最後欄位 / =OFFSET(B1,COUNTA(B:B)-1,0)

公式/名稱管理員/

data_bbb

data_ccc

data_ddd

data_eee

data_fff

data_ggg

=OFFSET('dis1'!$B$2,0,0,COUNTA('dis1'!$B:$B)-1,1)

=OFFSET('dis1'!$C$2,0,0,COUNTA('dis1'!$C:$C)-1,1)

=OFFSET('dis1'!$D$2,0,0,COUNTA('dis1'!$D:$D)-1,1)

=OFFSET('dis1'!$E$2,0,0,COUNTA('dis1'!$E:$E)-1,1)

=OFFSET('dis1'!$F$2,0,0,COUNTA('dis1'!$F:$F)-1,1)

=OFFSET('dis1'!$G$2,0,0,COUNTA('dis1'!$G:$G)-1,1)

格式/對齊/貼齊格線

=SERIES('dis1'!$E$1,'dis1'!data_bbb,'dis1'!data_eee,1)

=SERIES('dis1'!$G$1,'dis1'!data_bbb,'dis1'!data_ggg,2)

ctrl + [->]

ctrl + shift + [->]

=(HOUR(A2)*3600)+(MINUTE(A2)*60)+SECOND(A2)