Redian新闻
>
借人气,问哪个EXCEL函数问题能解决这个问题
avatar
借人气,问哪个EXCEL函数问题能解决这个问题# Hardware - 计算机硬件
p*1
1
有一堆基因名字(可能同一基因出现若干次),希望能用函数列出每个基因名字出现了
多少次?
avatar
i*t
2
countif()

【在 p*********1 的大作中提到】
: 有一堆基因名字(可能同一基因出现若干次),希望能用函数列出每个基因名字出现了
: 多少次?

avatar
p*h
3
用subtotal功能

【在 p*********1 的大作中提到】
: 有一堆基因名字(可能同一基因出现若干次),希望能用函数列出每个基因名字出现了
: 多少次?

avatar
h*e
5
pivot table更快更简单
avatar
y*j
6
装R,免费的,然后把你的excel存成csv
进R
table(read.table("路径/XXX.csv"))
0610007L01Rik 0910001A06Rik 1200002N14Rik 1700012H17Rik 1700030J22Rik
1810055E12Rik 2010309E21Rik 2210010L05Rik
15 19 10 5 4
12 9 14
2310022M17Rik 2310035C23Rik 2310044G17Rik 2410014A08Rik 2510039O18Rik
2600010E01Rik 2610030H06Rik 2700050L05Rik
11 16 9 14 15
16 17 12
2810405J04Rik 2810474O19Rik 3110048E14Rik 41162 4432412L15Rik
4631416L12Rik 4732418C07Rik 4833426J09Rik
30 13 12 7 10
12 12 4
4930506M07Rik 4930535B03Rik 5730419I09Rik 5730470L24Rik 6030443O07Rik
6720456H20Rik 9030625A04Rik 9930021J17Rik
11 13 14 8 12
19 7 16
A430107O13Rik A930005I04Rik A930041I02Rik AK220484 AU040320
Aadacl1 Aak1 Abca1
12 8 13 26 12
22 10 16
Abcc4 Abhd2 Abhd5 Abi2 Abl2
Abr Acbd5 Acsl3
14 9 13 14 30
14 17 19
Acvr1c Adam10 Adam12 Adam17 Adam19
Adam23 Adam9 Adamts18
20 18 14 17 15
20 10 28
Adamts19 Adm Adrbk1 Adrbk2 Agxt2l1
Akap7 Als2 Als2cr2
16 17 6 10 7
13 10 30
Ankib1 Ankrd11 Ankrd52 Anks1 Anks1b
Ap1s3 Apcdd1 Appl1
19 17 23 17 19
14 13 2
Arhgap21 Arhgap26 Arhgef12 Arhgef3 Arid2
Arid3a Arl4c Arl5b
20 14 13 12 19
19 9 17
Armc1 Armcx2 Arpp19 Arpp21 Ascl2
Asph Aspn Atad2b
15 13 27 15 6
3 16 18
Atf2 Atp10a Atp11c Atp1a2 Atpaf1
Atxn7 B3gnt5 B4galt1
15 10 12 14 11
21 16 18
BC004044 BC021891 BC023744 BC057371 BC063749
Bace2 Bak1 Baz2b
2 8 11 15 8
2 10 18
Bcl7b Bcr Bhlhb2 Bhlhb5 Bicd2
Bid Bmp2k Braf
12 11 17 17 18
7 13 15
Brap Btbd14a C030004A17Rik C2cd2l Cacnb4
Camsap1 Camsap1l1 Caprin1
9 30 14 15 17
29 27 4
Capza1 Carm1 Cblb Ccdc131 Ccdc28a
Ccdc6 Ccdc67 Ccnc
26 12 16 19 16
17 10 9
Ccnd1 Ccnd2 Ccnj Ccnjl Cd200
Cd2ap Cdc2l5 Cdh11
3 18 17 15 14
14 19 21
Cdh2 Cdh20 Cdh4 Cdk2ap1 Cdk5r1
Cdk8 Cdr2l Cdv3
18 16 16 19 10
35 15 8
Cebpg Celsr1 Centb2 Cep68 Chac1
Chd5 Chfr Chordc1
15 8 17 8 16
11 17 17
Chsy1 Clasp2 Cnr1 Cntn3 Col10a1
Col11a1 Col19a1 Col1a2
19 16 16 8 16
16 17 15
Col5a1 Commd8 Cops2 Cops7b Cpeb3
Cpsf2 Cradd Cramp1l
14 11 19 14 20
11 7 11
Creb1 Crebl2 Crebzf Crlf3 Csnk1g1
Cstf2 Ctdsp2 Ctgf
11 12 16 8 18
13 16 19
Cth Ctnnbip1 Ctnnd2 Ctsl Cttnbp2nl
Cugbp2 Cxadr D030056L22Rik
11 13 14 8 14
44 12 11
D130059P03Rik D14Abb1e D230025D16Rik D3Ucla1 D430041D05Rik
Dab2 Dapk1 Dcbld1
41 12 15 17 14
14 13 12
Dcbld2 Dcdc2a Ddr2 Ddx17 Ddx3x
Ddx46 Depdc1b Depdc6
23 14 11 16 17
7 12 11
Dlg4 Dmrt3 Dmxl1 Dnaja1 Dnajb5
Dnm1l Dnmt3a Dnmt3b
12 13 12 6 11
5 32 14
Dyrk1a E2f7 E330018D03Rik EG574403 Eaf1
Eif2s1 Eif4g2 Eif5
19 36 15 12 27
9 37 13
Elavl2 Eml5 Enc1 Ep400 Epb4.1l3
Epc1 Epc2 Epha2
36 11 14 13 15
18 40 13
Epha5 Erc2 Ermp1 Ero1lb Esam1
Etv3 Eya3 Ezh2
16 19 14 18 11
16 18 17
Fa2h Faf1 Fbxl19 Fbxo11 Fbxo28
Fbxo42 Fgd1 Fkbp3
14 7 23 19 33
18 16 10
Flvcr1 Fnip1 Fosl2 Foxj3 Foxp2
Frat2 Frmd4b Fubp1
6 11 12 10 18
11 19 13
Fusip1 G3bp2 Gabrb3 Gad2 Galnt10
Galnt7 Gata4 Gats
8 18 14 18 14
17 13 9
Gcap14 Ghsr Giyd2 Gm1337 Gm50
Gm606 Gm608 Gmeb1
15 11 7 16 5
6 11 8
Gmfb Gna13 Gnpnat1 Gpsm1 Gramd1c
Grb10 Grhl3 Gsk3b
14 16 13 12 13
13 17 20
Gtf3c2 Hao1 Hapln1 Has3 Hectd3
Hgf Hiat1 Hipk1
9 12 9 14 13
35 19 20
Hipk2 Hmga1 Hmga2 Homer1 Hoxa5
Hoxd13 Hpgd Hspa13
13 12 17 17 18
15 15 10
Hspa4l Huwe1 Igf1 Il17rd Il1rapl2
Inhbb Insig1 Ints2
9 17 18 2 4
19 10 12
Intu Ipmk Itga5 Itpr1 Jag1
Jarid2 Kbtbd8 Kcne4
11 14 14 20 20
17 18 19
Kcnj2 Kcnk1 Kcnn3 Kcnq4 Kif21b
Klf4 Klhdc5 Klhl11
20 10 14 15 13
19 22 9
Klhl18 Kpna2 Kpna6 Larp5 Lhfpl4
Lims1 Lingo1 Lman1
9 17 29 38 12
16 18 16
Lnp Lnpep Lnx2 Lonrf3 Lphn1
Lrch1 Lrrc16a Lrrtm4
13 16 23 6 12
18 15 16
Lsm11 Lsm12 Ltbp1 Mab21l1 Maea
Man2a1 Map3k2 Map3k7
14 18 15 35 10
17 17 14
Mapk1ip1l Mapk6 Mat2a Mcc Mdn1
Med13l Metap2 Mex3c
8 16 19 10 15
17 7 19
Mfap3 Mfhas1 Mgat4a Mier3 Minpp1
Mknk2 Mkrn3 Mll3
5 25 14 19 4
7 11 20
Mllt3 Mmp12 Mnat1 Mnx1 Mras
Mrvi1 Mtap1a Mtap1b
12 6 11 12 12
5 14 20
Mtap2 Mtap7 Mtap9 Mtdh Mtm1
Mtmr1 Mtpn Mtx2
21 15 9 18 15
9 17 12
Mxi1 Myo5b Nab1 Nampt Nap1l5
Narg1 Nars Ncoa4
16 13 16 18 20
20 2 10
Ndfip2 Nek6 Neto1 Nhsl1 Nid1
Nlk Npal2 Nudt11
8 13 20 13 10
41 6 12
Nup153 Nup210 Nup50 Oaf Obfc2a
Ocln Osbpl11 Osbpl2
20 8 13 13 19
11 28 12
Otud4 P2ry1 Pag1 Pak2 Pawr
Pcdh18 Pcdh9 Pcgf3
37 12 9 16 17
12 17 9
Pcnx Pdcd10 Pde4b Pdhx Pdik1l
Pecam1 Peli2 Pex13
24 35 13 16 11
13 10 6
Pfkfb3 Pgm2l1 Pgr Phf20l1 Phf21a
Phf3 Phf6 Phldb2
14 14 10 40 17
16 15 12
Pias1 Pik3c2a Pik3r3 Pim1 Pitpnc1
Plekhf2 Plekhm3 Plod2
17 14 17 15 19
4 10 31
Plxna2 Pmaip1 Pmepa1 Polr3g Pom121
Ppig Ppm1b Ppm1h
17 6 4 9 13
17 18 10
Ppp2r5a Ppp3cb Ppp3r1 Ppp4r1 Prkab1
Prkag2 Prkcb1 Prkcd
15 16 18 19 4
15 7 17
Prkcq Prrc1 Prss35 Psd3 Ptchd1
Pten Ptgs2 Ptp4a1
13 10 11 17 9
54 14 18
Ptpn13 Ptprd Pygo2 Rab11fip1 Rab21
Rab31 Rab3ip Ranbp10
18 21 8 11 13
6 10 15
Ranbp9 Rap2c Rassf3 Rb1 Rbm24
Rbm47 Rcbtb1 Rcn1
20 18 16 10 19
17 12 13
Rcn2 Rdh14 Reep3 Reep4 Rell1
Ret Rffl Rgs4
14 11 24 14 12
7 2 12
Rlf Rnf215 Rnf6 Rpgr Rps6ka2
Rps6ka6 Rps6kc1 Rqcd1
34 5 15 15 5
14 10 9
Rspry1 Rtf1 Rtn1 Rufy3 Ryk
Sall1 Sall3 Samd8
15 27 20 13 12
17 13 12
Sbno1 Scamp1 Scml4 Scoc Sema6d
Senp5 Serbp1 Setd8
38 12 14 10 18
19 35 14
Sfxn1 Sgcb Sh3d19 Sh3rf1 Shc4
Skil Skp2 Slc12a2
7 4 27 18 11
12 12 14
Slc16a6 Slc19a2 Slc1a1 Slc22a23 Slc25a16
Slc25a20 Slc25a37 Slc2a13
24 7 16 25 30
17 16 7
Slc2a3 Slc35a3 Slc38a2 Slc4a4 Slc6a6
Slc7a11 Slc7a6 Slc9a2
11 11 20 16 16
9 11 15
Slco5a1 Smad1 Snn Snx30 Socs7
Sox17 Spnb2 Spock2
15 40 16 12 11
12 12 12
Spred2 Srp19 Ssx2ip St8sia4 Stac2
Stk39 Stk4 Stox2
3 10 16 14 14
38 12 25
Strbp Stxbp5 Styx Sulf1 Suv420h2
Taf13 Taf9b Tanc2
38 14 18 30 11
8 12 27
Tank Taok1 Tbc1d12 Tbc1d13 Tbc1d15
Tbc1d4 Tcfap2a Tcfap2c
12 17 10 10 14
19 20 13
Tcfap2e Tcp11l2 Tesk2 Tet2 Tfdp1
Thap2 Thrap3 Tial1
14 11 18 77 3
13 13 15
Tiam1 Tigd4 Tmc7 Tmed10 Tmem123
Tmem14a Tmem184b Tmem2
9 7 9 7 3
2 12 14
Tmem20 Tmem206 Tmem33 Tmem56 Tmem68
Tmem86a Tmtc3 Tnks1bp1
9 10 11 13 11
14 12 13
Tnrc6a Tnrc6b Tnrc6c Tob1 Tppp
Tram1 Trib2 Trp53inp1
16 38 18 19 12
11 20 32
Trp53inp2 Trpc3 Trps1 Tsc22d2 Tspan14
Tspyl4 Ttc13 Ttc9c
17 18 18 14 9
12 15 9
Ttpal Tub Twf1 Txndc4 Ubac1
Ube2d1 Ube2e2 Ube2g1
12 14 13 14 4
18 16 30
Ube2k Ube3a Ube4b Ubr1 Ubtd2
Ugt8a Ulk1 Ulk2
12 18 19 12 14
16 15 20
Usp15 Usp25 Usp3 Usp48 Usp9x
Utx Uty Vangl2
18 12 21 16 33
17 5 12
Vdac3 Vps33a Wdr68 Whsc1 Whsc1l1
Wipf2 Wnk1 Wnt5a
6 8 12 15 13
16 19 10
Xkrx Xpot Ypel1 Ythdf3 Ywhae
Zbtb16 Zbtb33 Zbtb39
11 4 9 14 18
14 3 9
Zbtb7c Zc3h7b Zcchc2 Zcchc24 Zdhhc18
Zdhhc20 Zdhhc6 Zfhx3
13 13 20 33 16
14 18 17
Zfhx4 Zfp106 Zfp148 Zfp192 Zfp217
Zfp238 Zfp275 Zfp385b
20 9 12 6 13
20 15 19
Zfp410 Zfp462 Zfp598 Zfp608 Zfp650
Zfp655 Zfp710 Zfx
16 37 15 18 17
14 11 16
Zfyve20 Zkscan1 Znrf3 Zswim5
6 14 15 14
发包子吧
相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。