[算表] 儲存格內 是否包含某些資料
軟體:
EXCEL
版本:
2003
資料內容 計算區
B1=BOX C1=(找出B1包含幾個X)
B2=Boyzone C2=(找出B2包含幾個X)
B3
B4
↓
我想找的公式是 可以計算出 B的儲存格中 是否包含 x
例如 B1內容是 "BOX" 然後 C1 = 1
B2內容是 "Boyzone" C2 = 0
只要有包含 就算 當然 如果可以算出 有幾個的話 更好
謝謝
--
Do you like Germany
Ya!I like Germany.... but not Germany. I Like German History.
Very strong will, Very deligent people.......
(in a word)The Great Germany(Das Gross Deutschland)
I don't Like the American one, the American one no good,
They Pretend,(We're justice,peace,democracy......)
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 123.194.135.134
→
04/15 19:41, , 1F
04/15 19:41, 1F
推
04/15 19:47, , 2F
04/15 19:47, 2F
→
04/15 19:51, , 3F
04/15 19:51, 3F
※ 編輯: rdws 來自: 123.194.135.134 (04/15 20:12)
推
04/15 20:19, , 4F
04/15 20:19, 4F
推
04/15 20:23, , 5F
04/15 20:23, 5F
→
04/15 20:24, , 6F
04/15 20:24, 6F
→
04/15 20:25, , 7F
04/15 20:25, 7F
→
04/15 20:26, , 8F
04/15 20:26, 8F
推
04/15 20:29, , 9F
04/15 20:29, 9F
→
04/15 20:43, , 10F
04/15 20:43, 10F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
