[算表] 同一儲存格有多項資料 篩選
軟體:Excel
版本:2007
因為很多數據都位在同一儲存格內,如下
Limit Data (217.2) Alive (300sec) WiFi (1) IP (10.24.84.167) Network (WCDMA)
Data (2,220.3) Band (8) Signal (-120dbm) Battery (94%)
Limit Data (1,027.1) Alive (300sec) WiFi (1) IP (10.16.34.41) Network (LTE)
Data (8,714.3) Band (3) Signal (-95dbm) Battery (Charge)
Limit Data (1,027.1) Alive (300sec) WiFi (0) IP (10.24.64.234) Network (LTE)
Data (8,714.3) Band (3) Signal (-97dbm) Battery (Charge)
Limit Data (744.3) Alive (300sec) WiFi (1) IP (10.26.120.253) Network (LTE)
Data (7,607.3) Band (3) Signal (-92dbm) Battery (50%)
現在我要單就"(-XXdbm)",做數值比較
要如何
1.單獨把那個值抽出來,顯示在其它行
或是
2.直接依大小進行篩選,ex:只顯示數值介於-90~-95間的儲存格
謝謝各位高手
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 1.160.88.122
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1441086978.A.E30.html
→
09/01 14:59, , 1F
09/01 14:59, 1F
→
09/01 15:00, , 2F
09/01 15:00, 2F
→
09/01 15:01, , 3F
09/01 15:01, 3F
→
09/01 15:04, , 4F
09/01 15:04, 4F
→
09/01 15:07, , 5F
09/01 15:07, 5F
→
09/01 15:52, , 6F
09/01 15:52, 6F
→
09/01 18:10, , 7F
09/01 18:10, 7F
→
09/01 18:10, , 8F
09/01 18:10, 8F
→
09/02 15:29, , 9F
09/02 15:29, 9F