作者查詢 / someone
作者 someone 在 PTT [ Office ] 看板的留言(推文), 共54則
限定看板:Office
看板排序:
全部Japan_Travel228Math193studyteacher125Teacher103Taoyuan65Office54puzzle45Kawashita42Rubiks20tutor18points17Wrong_spell16Hiking12Lifeismoney10creditcard9HK_Comics9EarthScience6Keelung6KingdomHuang6SpaceArt6FixMyHouse5NSwitch5Ocean5TakahasiShin5hypermall4Interior4kachaball4AVEncode3HwangYih3MJ3NTU-HOLATEAM3DailyArticle2EZsoft2Gossiping2KS98-3022MobilePay2Singapore2teaching2bookhouse1CKSC1CS15th3441Facebook1Hong_Kong1Inference1iOS1Key_Mou_Pad1KOTDFansClub1KS94-3161LivingGoods1LordsOfWater1love-vegetal1marvel1poem1sex1Soft_Job1Trace1travel1YOLO1<< 收起看板(58)
3F→: 感謝01/13 10:07
2F→: thx06/22 16:58
1F→: 你需要的是 if 函數04/30 13:41
4F推: 照這樣 不就把A欄複製到B欄就好了嗎?04/30 13:40
2F→: =LEFT(SUBSTITUTE(A1,".",""),7)04/16 23:26
1F→: =(a1-0.7)*0.6/0.14+0.703/31 13:52
1F→: 對B欄做排序或篩選,應該就可以了03/16 22:53
1F→: 把地址切開來做,做完再合併吧。03/10 10:16
2F→: 要求中位數,就一定要算累積次數,>=1/2總和那組就可以了03/05 23:28
3F→: 人數下面要加一列累積人數,這樣比較好下手03/05 23:29
1F→: 用lookup函數02/09 18:19