search

JohnD59 / work

0 stars 0 forks source link

excel 函數 #10

Open JohnD59 opened 1 year ago

JohnD59 commented 1 year ago

可以快速尋找前面有幾個內容 =CONCATENATE("(", CHOOSE(COUNTIF(A5:E5,"<>"&"")+1, "一", "二", "三", "四", "五","六"), ") ", "我是妳嬤嬤")