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 的大作中提到】
: 可以用function里的max来做。当然如果列表太长，这不是一个最有效的办法。
|
h****n
发帖数: 2552 | 6 不行，还得pick up出来啊
【在 d*p 的大作中提到】
: 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 的大作中提到】
: 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 的大作中提到】
: 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.
|
