h****n 发帖数: 2552 | 1 大家帮帮忙,在excel表里面,我一个基因对应很多个peakvalue,我想只取和基因对应
的最高的一个peak value,然后看有多少个基因,请问该怎么做呢? |
h****n 发帖数: 2552 | |
m***T 发帖数: 11058 | 3 可以用function里的max来做。当然如果列表太长,这不是一个最有效的办法。 |
d*p 发帖数: 534 | |
h****n 发帖数: 2552 | 5 有几万行...
【在 m***T 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 可以用function里的max来做。当然如果列表太长,这不是一个最有效的办法。
|
h****n 发帖数: 2552 | 6 不行,还得pick up出来啊
【在 d*p 的大作中提到】![](/moin_static193/solenoid/img/up.png) : sort
|
M*******a 发帖数: 15 | 7 Let's say, genes in column A and peakvalues in column B
(from row x to row y)
1. Sort whole dataset by columns A & B (A to Z and smallest to largest)
2. Fill rows x to y in column C with =countif(Ax:Ay, Ax)
3. Copy column C and paste special "value" to column D
4. Sort whole dataset by columns D & A (smallest to largest, A to Z)
The data you want will be shown at the top of the sheet with "1" listed in
column D. |
h****n 发帖数: 2552 | 8 谢谢,computer choke了。刚才做了一小部分,同样的genesymbol,为什么在column后
面的数字不一样?我理解你的公式的意思是计算A中每一个单元格在A column里面的重
复个数对不对?
【在 M*******a 的大作中提到】![](/moin_static193/solenoid/img/up.png) : Let's say, genes in column A and peakvalues in column B : (from row x to row y) : 1. Sort whole dataset by columns A & B (A to Z and smallest to largest) : 2. Fill rows x to y in column C with =countif(Ax:Ay, Ax) : 3. Copy column C and paste special "value" to column D : 4. Sort whole dataset by columns D & A (smallest to largest, A to Z) : The data you want will be shown at the top of the sheet with "1" listed in : column D.
|
h****n 发帖数: 2552 | 9 got it。多谢,就是机器算起来有点吃力:)
【在 M*******a 的大作中提到】![](/moin_static193/solenoid/img/up.png) : Let's say, genes in column A and peakvalues in column B : (from row x to row y) : 1. Sort whole dataset by columns A & B (A to Z and smallest to largest) : 2. Fill rows x to y in column C with =countif(Ax:Ay, Ax) : 3. Copy column C and paste special "value" to column D : 4. Sort whole dataset by columns D & A (smallest to largest, A to Z) : The data you want will be shown at the top of the sheet with "1" listed in : column D.
|