close

比對文字

=EXACT(A1,B1)
相等TRUE | 不相等FALSE

計算範圍內符合指定條件儲存格的數目

=COUNTIF(F:F,F1)

 

=CHOOSE(H2,"黃蘋果","黃香蕉","黃水果","黃aa","黃bb","黃cc","黃dd","黃rr","黃ee")

選中C1:E3，輸入“={"Name", "Sex", "Age"; "John", "Male", 21; "Mary", "Female", 20}”，按“Ctrl+Shift+Enter”組合鍵。

arrow
arrow
    全站熱搜

    heres 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄