<menu id="suuyg"><code id="suuyg"></code></menu>
  • <menu id="suuyg"><nav id="suuyg"></nav></menu>
    <tt id="suuyg"><tt id="suuyg"></tt></tt>
  • <xmp id="suuyg">
  • <nav id="suuyg"></nav>
    <nav id="suuyg"></nav>
    Question to say "I can!"

    職場人士必會的14個函數公式

    2016-12-21

    今天分享幾個模式化的表格公式,大家有類似問題可以直接套用。各位新人朋友們入門學習可以看看,高手請按返回鍵。

    1
    查找重復內容
    =IF(COUNTIF(A:A,A2)>1,"重復","")

    2
    重復出現兩次以上提示
    =IF(COUNTIF(A$2:A2,A2)>1,"重復","")

    3
    根據出生年月計算年齡
    =DATEDIF(A2,TODAY(),"y")

    4
    根據身份證號提取出生年月
    =--TEXT(MID(A2,7,8),"0-00-00")

    5
    根據身份證號碼提取性別
    =IF(MOD(MID(A2,15,3),2),"男","女")

    6
    幾個常用匯總公式
    A列求和:=SUM(A:A)
    A列最小值:=MIN(A:A)
    A列最大值:=MAX (A:A)
    A列平均值:=AVERAGE(A:A)
    A列數值個數:=COUNT(A:A)

    7
    考核成績排名
    =RANK(A2,A$2:A$7)

    8
    中國式排名
    相同成績不占用名次
    =SUMPRODUCT((B$2:B$7>B2)/COUNTIF(B$2:B$7,B$2:B$7))+1

    9
    統計90分以上人數
    =COUNTIF(B1:B7,">90")

    10
    統計各分數段人數
    同時選中E2:E5,輸入以下公式,按Shift+Ctrl+Enter
    =FREQUENCY(B2:B7,{70;80;90})

    11
    統計男生平均分
    =AVERAGEIF(B2:B7,"男",C2:C7)

    12
    多條件統計平均值
    =AVERAGEIFS(D2:D7,C2:C7,"男",B2:B7,"銷售")

    13
    統計不重復個數
    =SUMPRODUCT(1/COUNTIF(A2:A9,A2:A9))

    14
    提取不重復內容
    C2單元格輸入以下數組公式,按Ctrl+ Shift+Enter,向下復制。
    =INDEX(A:A,1+MATCH(,COUNTIF(C$1:C1,A$2:A$10),))&""

    作者:admin | Categories:辦公能手 | Tags:

    發表評論

    電子郵件地址不會被公開。 必填項已用*標注

    *

    日彩网平台日彩网主页日彩网网站日彩网官网日彩网娱乐 www.5187575.com | www.yl00444.com | df8i.com | www.82142.com | 4646755.com | www.8905y.com | 22296oo.com | www.783709.com | www.25msc.com | j86811.com | www.522665.com | 3121v.com | www.620239.com | www.567711.com | 88021e.com | www.zmfqp.com | 5855.com | 668cp55.com | www.88553.com | a5aaa.com | www.c177.com | www.72tk.com | 9737dd.me | www.50074d.com | www.39695y.com | zz.org | www.98xpj98.com | 6830c.com | www.021037.com | www.wy8008.com | 08159c.com | www.935257.com | www.303365.com | 444000ff.com | www.hx6600.com | www.hga8181.com | 3032.com | www.371v.cc | www.080678.com | vv879202.com | www.636by.com | www.457777.com | 2021eee.com | www.6832s.com | www.8k365.com | 048zz.com | www.946689.com | www.138cpn.com | 50099y.com | www.354811.com | www.71071f.com | 14683333.com | 71005.com | www.c63568.com | www.525xpj.com | 9007004.com | www.4963ee.com | 2544c2.com | 20188i.com | www.777xx.cc | www.360msc.com | 881133xl.com | www.c4526.com | www.48234h.com | 3568t.com | www.544646.com | www.8888hj.com | 6363d.com | 6220.com | www.9356l.com | www.84786.com | 98345l.com | 5446v.com | www.6939s.com | www.5651e.com | 1259r.com | www.709337.com | www.hg98j.com | 7168813.com | uu1916.com | www.pj8819.com | 58802k.com | www.c528.vip | www.89677b.com | www.3aobo.com | 95456.com | www.al5888.com | www.0012737.com | www.tyc163.com | hd81366.com | www.978127.com | www.71071n.com | www.ylhg3838.com | 69096c.com | www.582062.com | www.69567o.com | www.7893w2.com | d67890.com | fhcp127.com | www.00840i.com | www.832365.com | vip9895.com | amhj.com | www.389644.com | www.7240x.com | www.me6622.com | 418923.com | 3679ee.com | www.3126n.com | www.bwinyz27.com | www.7025p.com | 878365mm.com | 5589v.com | www.610829.com | www.97828d.vip | www.3688mhd.com | 500000914.com | 74399999.com | 3379qq.com | www.50051r.com | www.bet91484.com | www.88837g.com | 11005q.com | 2078v.com | www.362322.com | www.55vn777.com | www.3122uu.com | www.8806js.com | 80878w.com | 88992007.com | www.904859.com | www.pj55717.com | www.hg8201.com | 20775588.com | 23599m.com | 2247hh.com | www.962387.com | www.993956.com | www.q456x.com | www.56520i.com | 68228r.com | 55984i.com | www.177478.com | www.16878k.com | www.5182889.com | www.00166b.com | www.bet888365.com | 22117r.com | 3mgmvvv.com | www.303467.com | www.8039n.com | www.60886p.com | www.6789wh.com | www.vip.ra8.vip | df8u.com | 566777o.com | 38345r.com | www.235953.com | www.cbw222.com | www.x33678.com | www.4963hh.com | www.9411.am | www.63877p.com | 500000744.com | sbd030.net | ss8159.cc | www.202417.com | www.3668s.com | www.8577a.cc | www.1851132.com | www.23886.com | www.97780099.net | www.x30226.com | jnn003.com | 28839d.com | 6033b.com | 3550c.com | nn32355.com | www.555446.com | www.089d.cc | www.0194001.com | www.331068.com | www.2805.com | 228888s.com | n62365.com | www.33598v.com | www.552358.com | www.870080a.com | www.66332z.com | www.6889771.com | www.99553.com | www.xpj2060.com | www.932285555.com | www.hg9665.com | www.6suncity.com | www.3459p.com | www.9999wns.com | 1259z.com | 3009r.com | 8036o.com | 61322211.com | w15666.com | 3467j.am | 4255yyy.com | bmw8077.com | 0015mm.com | 9694o.com | 2008kk.com | 1775vv.com | 80850e.com | 3mgmmmm.com | 56988a.com | 88021.com | 9949.com | 3258r.com | 3121ll.com | 4637766.com | 3434eee.com | 3122027.com | qijidianyou.com | 3405e.com | 61653.com | sha0777.com | 2222k8.com | vns700.net | 6630081.com | 1408z.com | pp8662.com | 8381r.com | 82365u.com | 1466o.com | wlb33.com | JS1388f.com | 0747w.com | 131v.net | www.t32126.cc | www.76543b.com | www.7607633.com | www.015456.com | www.hg0699.com | www.998855d.com | www.38345j.com | www.hjdc2008.com | www.32638.com | www.55676j.com | www.win1231.com | www.hg8268.com | www.50051s.com | www.kc56.com | www.324277.com | JS1388k.com | bet3659091.com | zz76669.com | 8344dd.com | 55545r.com | 8185v.com | www.474.net | www.vnsr388.com | www.5008637.com | www.06820d.com | www.3a002.com | www.29277r.com | www.911209.com | www.180209.com | kk3373.com | 6175a.com | 7003r.com | zzc55.com | www.pj2768.com | www.9949f.com | www.lfcp123.com | www.x063801.com | www.5647e.com | www.fz34.com | 55797r.com | 3559w.com | mg6888.com | vnsr99888.com | www.58777e.com | www.1667777.com | www.88325e.com | www.52303r.com | www.659789.com | 6175uu.com | 915902207.com | 052979.com | www.99999jsc.com | www.447334.com | www.v01888.com | www.66652c.com | www.536210.com | 66681m.com | v4255.com | 97799d.com | www.6834j.com | 0207200.com | 2190t.com | www.hai0000.com | www.50999n.com | www.55238b.com | www.633813.com | 1077ii.com | sss40033.com | www.hg22888.net | www.70678d.com | www.297555.com | www.911888a.com | 11229193.com | 9998jsc.com | www.yh4959.com | www.98bgo.com | www.3978v.com | www.316530.com | 566670077.com | 6175oo.com | www.064808.com | www.z2894.com | www.022ah.cc | 6403v.com | 44uu8332.com | www.331393.com | www.js99938.com | www.gai50.com | 33567z.com | 338333.com | www.hj200766.com | www.cn365g.com | www.281877.com | 22p1.cc | 998z.cc | www.7172211.com | www.js89j.vip | www.869576.com | 3473v.com | 2767e.com | www.696111.com | www.62979w.com | www.818646.com | 19991i.com | 4694c.com | www.55526s.com | www.50026b.com | 272uu.net | 8569811r.com | www.js934.com | www.hg8889.tw | www.66653v.com | 35222k.com | www.k3355b.com | www.780780g.com | www.399140.com | 8006010.com | www.55268ii.com | www.990893.com | www.391109.com | w7776.com | www.58777f.com | www.68365b.com | www.225075.com | 4556z.com | www.vv2649.com | www.6889793.com | xcant.net | hwcp22.com | www.93342.com | www.5095i.com | 667766t.com | www.185ks.com | www.xj6006.com | www.506477.com | 3405zz.com | www.688222.com | www.77801m.com | 1389kk.com | www.sjs05.com | www.n3410.com | www.178753.com | 00003365.com | www.csh365.com | www.c1636.com | hwcpkjw.com | www.hg1557.com | www.81678t.com | 4060gg.com | www.38200o.com | www.1764d.com | 7935e.com | 272ww.net | www.55060v.com | 22296jj.com | www.bwinyz06.com | www.068630.com | zhcp63.com | www.d69096.com | www.175905.com | 7742o.com | www.d69096.com | www.178211.com | a444000.com | www.mgm555555.com | www.087069.com | 3005.am | www.xpj16688.com | gh7106.com | 365vip07.win | www.7920v.com | 8294d.com | www.hgw0088.me | www.77801y.com | 6002s.com | www.61456.com | www.cc6769.com | 1591aaa.com | www.tyc131.com | www.025069.com | d8501.com | www.4809f.com | 4123ss.com | www.1238760.com | www.5854e.cc | 3467w.am | www.00772b.com | 79889x.com | www.hg098.com | www.4648.cc | 7141.com | www.j9478.com | www.196309.com | 500000413.com | www.178337.com | 4812g.com | www.87849.com | www.533721.com | wfcp000111.com | www.234567.pw | 9679x.com | www.185hwx.com | www.186287.com | www.h67783.com | www.99677k.com | 00xpj377.com | www.cn365t.com | 99111gg.com | www.yh04b.com | www.645977.com | 8290j.com | www.8d878.com | 0289q.com | www.00618h.com | 44005156.com | www.20180077.com | www.431016.com | www.glc55.com | www.53900q.com | ss00558.com | www.2848bbb.com | 52688p.com | www.cjcp345.com | 6969xpj.com | www.x9016.com | www.707232.com | 5003ff.com | www.68568k.com | 26789.com | www.5446j.com | 5443n.com | www.9737jj.me | uuu5144.com | www.3589888.com | hj5068.com:8888 | www.535msc.com | www.602430.com | www.hg3388.tw | www.zcwf0.com | 3222j.cc | www.022xz.cc | 97297d.com | www.9478l.com | dh2267.com | www.68568p.com | y68147.com | www.40wb.top | 55331q.com | www.300726.com | so222.cc | www.68993239.com | am9649.com | www.xb8844.com | pj900.cc | www.70203d.cc | long397.com | www.4323k.com | qq365u.com | www.50064g.com | 463wu.com | www.3126a.com | pj677g.com | www.hjin2.com | www.xpj1111.cc | www.755690.com | www.2090933.com | www.496689.com | www.29886j.com | www.108097.com | www.hg56555.com | rml0.com | www.81306b.com | 2546q.com | www.5377msc.com | 518cp-9.com | www.yk222c.com | 5651k.com | www.556939.com | 435796.com | www.5337933.com | 22556i.com | www.bai84.com | www.amvip555.com | www.055972.com | www.03808.com | 2643g.com | www.115527o.com | 78808h.com | www.66652b.com | 6218.com | www.190882.com | www.643sunbet.com | 2542277.com | www.30350t.com | hjdc789.com | www.5086x.com | www.he0066.com | 5144.cc | www.1168i.com | nn500o.com | www.50052hh.com | www.8805js.com | www.177542.com | www.jbb2017.com | 56988bb.com | www.16065x.com | 7js345.com | www.330587.com | www.pj79777.com | 8520l.com | www.9646u.com | www.56733o.com | www.68682a.com | www.27363l.com | jj4255.com | www.9356p.com | www.535msc.com | 66300vip19.com | www.0600y.cc | feicai0917.com | www.505170.com | www.09848.com | 11005n.com | www.29277y.com | www.7025w.com | 3mgmooo.com | www.33668.com | bg345.com | www.50051o.com | www.92302.com | pjxianggang.com | www.703617.com | www.0748.cc | gg40033.com | www.sygj1.com | www.hg0019.com | 98345m.com | www.7793z.com | www.cs55222.com | bet12306420.com | www.50026n.com | www.66166s.com | 81511t.com | www.50024c.com | www.pj7058.com | 827720.com | www.820031.com | xbqjn.com | yzc596.com | www.xpj8118.com | www.sjg118.com | 32126c.net | www.6678565.com | www.365699.com | 1468yyy.com | www.84499l.com | www.ao299.com | 2820z.com | www.99clf.com | www.63208.com | z40033.com | www.djcp007.com | www.8473n.com | 2418005.com | 4992535.com | www.68993269.com | www.mmtx22.com | 111122ee.com | www.qilc3.com | www.88552055.com | 472741.com | www.605999aa.com | www.894858.com | emr9836.com | 01885b.com | www.5958121.com | www.25288z.com | 3304f.com | www.795335.com | www.11tyc.com | 60876.com | 159666s.com | www.6661a.cc | www.a81c.cc | 518cp33.com | rr5443.com | www.50066c.com | www.681378.com | k353.com | kn8pe8fq.pp.163.com | www.15355hh.com | www.1555789.com | 55331ww.com | 50128.com | www.91233w.com | www.005596.com | 00ww8332.com | 518cp.com | www.57169.cc | www.668cp66.com | 139973.com | 6396u.com | www.803244.com | www.46630.net | www.hg7575.com | 8159m.cc | www.66332o.com | www.77537.com | www.888dsy.com | 2306e.com | 9484H.com | www.890402.com | www.p3410.com | www.32666j.com | 44009193.com | 2546z.com | www.80175.com | www.98698s.com | www.ag9655.com | 3568f.com | 6594ss.com | www.61655n.com | www.xy048.com | www.28758t.com | c4255.com | ra6616.com | www.7782u.com | www.3300ra8.com | www.xin888111.com | pj300.cc | 55cc.com | www.643388.com | www.42842807.com | www.tmx6872.com | www.55564400.com | yth005.net | bet577b.com | www.055i.cc | www.79095x.com | www.22201.com | 667766d.com | 69111h.com | c.kuktt.cn | www.qml7.com | www.c94600.com | www.17035.com | www.936699.com | 4107c.com | 33773885.com | www.383897.com | www.78949d.com | www.bwinyz33.com | www.28824s.com | 50024444.com | am775.cc | 3844oo.com | www.307281.com | www.138808.com | www.00038js.com | 370956.com | 6002f.com | www.177474.com | www.9478n.com | www.38775oo.com | www.addbl.com | www.40818b.com | 56988j.vip | hc096.net | 5589k.com | www.431056.com | www.54968g.com | www.12136f.com | www.2945d.com | www.hg5801.com | v01234.com | k70111.com | 144258.com | 1697.com | www.637477.com | www.50064s.com | www.184088.com | www.cai51.com | www.77605z.com | www.kim111.com | 3009e.com | 9659z.com | bm1398.com | 027652.com | www.339281.com | www.66ffb.com | www.yun1818.com | www.45598w.com | www.yingle55.com | www.5288js.com | www.8124b.com | yz01.cc | 148030.com | 2709q.com | www.202406.com | www.976891.com | www.66332c.com | www.3691z.com | www.781617.com | www.cp67773.com | www.xpj66989.com | www.js707.com | www.18xinli.cc | 7935y.com | 50067i.com | 4018nn.com | 2566h2.com | 8742p.com | 815077.com | 50128.com | www.43818e.com | www.500103.com | www.896010.com | www.11044.cc | www.71399k.com | www.yh70123.com | www.blr4444.com | www.9997058.com | www.8473y.com | www.0057d.com | www.369038.com | www.3688mhd.com | www.hg0782.com | www.0904xpj.com | www.333133l.com | www.6491y.com | 7811mm.com | 88021a.com | 2851y.com | 3844p.com | 5168ee.cc | 2851k.com | 8030q.com | 2455z.com | 8577b.cc | 55899i.com | 2299555.com | yth15.net | 2844x.com | feicai0410.com | 55818e.com | 30006g.com | 2851y.com | ca3055.com | 1591ccc.com | 6175r.com | www.yxlm33.com | www.5487567.com | www.28758r.com | www.yinhe9507d.com | www.yh6789.com | www.h067.com | www.0860p.com | www.418693.com | www.64821122.com | www.amjs9.com | www.068340.com | www.tmx6872.com | www.c155d.com | www.1700116.com | www.3157h.com | www.30k0048.com | www.88325h.com | www.877579.com | www.3775a.com | www.500166.com | www.66376w.com | www.3479v.com | www.996732.com | www.637477.com | www.170792.com | bcbm777.com | d47479.com | 206404.com | www5682.com | 53262kk.com | p9602.com | bst979.com | www.hg567000.com | www.140955.com | www.31399ee.com | www.rg666.com | www.06386688.com | www.x4449.com | www.52303g.com | www.hy5502.com | www.377474.com | 19991t.com | 3568cc.com | 00jidu.com | 986486.com | 5804y.com | www.550290.com | www.69880.com | www.1705.com | www.7036.com | www.81520h.com | www.cp703.vip | www.235944.com | 6137g.com | 3121ii.com | 80368u.com | 27878ll.com | www.32666i.com | www.984365.com | www.9997058.com | www.0601y.com | www.qmkl5.com | www.youxin9.cc | 1077zz.com | 4379y.com | 2506w.com | www.v3309.com | www.4583.com | www.80188j.com | www.85144.com | www.972283.com | am2017111.com | js559.net | 41178962.com | www.1882389.com | www.hga8181.com | www.pj88o.com | www.89777b.com | www.959589.com | 2595e.com | 22448332.com | 365bet800.com | www.hg7288.com | www.967808.com | www.78680d.com | www.0014r.com | www.43131e.com | www.c33668.com | www.41518y.com | www.369073.com | b899.xyz | 11ll8332.com | www.hggj.ac | www.35252z.com | www.vip7033.com | www.866505.com | xin98886.com | 77606f.com | www.hg9050.com | www.555305.com | www.7240w.com | www.861803.com | 3467y.am | 2078c.com | www.r22365.com | www.4972v.com | www.81678q.com | www.178387.com | 2v939.com | 69111h.com | 535.cc | www.47711.com | www.500558.com | www.651514.com | 3mgmiii.com | 56988j.com | www.166459.com | www.8905f.com | www.976917.com | 7811aa.com | 888zrgw58ylc.com | www.y36h.com | www.33678vv.com | www.977hf.com | qiji.ph | 11vv8331.com | www.864bet.com | www.88325q.com | www.c4520.com | 3788p.com | 7945zz.com | www.22997.com | www.35898f.com | www.253529.com | www.7920i.com | www.582062.com | vv00558.com | 1591ddd.com | www.135755555.com | www.35155q.com | 20774466.com | 8406.com | www.8898hg.com | www.8998977.com | www.076591.com | 9068i.com | www.2078f.com | www.8c777.com | www.506931.com | 97340011.com | www.40818b.com | www.6386c.com | www.551727.com | y1458.com | www.i22365.com | www.74737.com | www.523780.com | 32555p.com | www.hg56783.biz | www.89789v.com | www.51515v.com | xpj677f.com | www.118668.com | www.ky1004.com | xpj71333.com | 83377b.com | www.0057d.com | www.cp0123.cc | 22448332.com | www.9068ll.com | www.12345606.cc | www.68568o.com | js75bb.com | www.hg8201.com | www.9818m.cc | 58802e.com | www.28758a.com | www.509236.com | www.171109.com | 3522kk.com | www.3171114.com | www.666xm.cc | 556677882.com | www.51990.com | www.qiji666.com | 23800p.com | 56988n.vip | www.hg98.me | www.496918.com | xpj677f.com | www.333010.com | www.75gcw.com | 2381b.com | www.54541100.com | www.662365.cc | hg168o.com | www.56733z.com | www.7036kk.com | b9973.com | 8742aa.com | www.45598o.com | www.84499e.com | 228888g.com | www.c30666.vip | www.235892.com | xiaowei889.com | www.19yh7.com | www.351089.com | 61324477.com | www.90.tt | www.717699.com | rr56988.com | www.6880pp.com | 4182r.com | 2400010.com | www.5446z.com | qiji.ph | www.yh567.com | www.454647.com | 14119455.com | www.hg0770.com | www.7782w.com | 6943300.com | www.d444.com | www.670477.com | 08159s.com | www.xybets6.com | 38989s.com | 897ll.cc | www.030158.com | 5360ss.com | www.hg2367.com | www.022gs.cc | 01234kk.com | www.50999m.com | www.89894e.com | 20774499.com | www.68993277.com | 20042.com | www.70337.com | www.863012.com | 76886l.com | www.r32031.com | 99151z.com | www.hg015.com | www.266ak.com | vns80579.com | www.hyi158.com | 168c6.com | www.9068ll.com | www.5086d.com | 2214aa.com | www.88mgm777.com | yk802.com | www.9996oo.com | www.061wy.com | yf788.net | www.3032nn.com | 3331pay.com | www.xpj2638.com | www.665010.com | 0747xx.com | www.6939h.com | ctxcp300.com | www.11086.com | 86811n.com | www.benz4455s.com | www.1368d.cc | c5429.com | www.yh888c.com | 93922o.com | www.938o.cc | 1468ddd.com | www.360msc.com | www.832793.com | n2306.com | www.88266x.com | w3405.com | www.574546.com | 3559zz.com | www.68277777.com | www7893.cc | www.hgw0088.com | www.25288s.com | www.767387.com | 3822o.com | www.29277f.com | b2146.com | www.97828v.vip | 9007893.com | www.4996gg.com | 1389q.com | www.518175.com | 3189o.com | www.t0524.com |