|
I'm having a problem that I've spent ages trying to solve and I don't know if it's even possible. I have a list of genes and their expression from an array experiment, but several of the genes are represented more than once. Is it possible to average the values of the non-unique entries? Here is what I have now:  And here is what I want:  So for genes with a unique entry, like A2M, I just want the actual numbers, but for A1BG I need the average of two rows and for NAT1 I need the average of three rows. If it were only 20 rows, I'd do it manually, but there are >36,000 probes on the array and only about half of them are unique.
|
#
¿
Jul 20, 2011 16:51
|
|
|
|
| # ¿ May 14, 2024 04:05 |
|
|
Holy poo poo, how have I been using excel for this long and not known about that? Thank you so much!
|
|
#
¿
Jul 20, 2011 17:22
|
|
|
In word, Ctrl+F, click on replace. In the find box enter "^t" (without the quotation marks), and leave the replace box blank.
|
|
#
¿
Jul 21, 2011 13:27
|
|
|
I just tried this myself, and I think I've got it. If the following is the output you require: The formula you want is this: =IF(CR5<100,"FAIL",IF(CW5<100,"PASS",IF(DB5<100,"MERIT","DISTINCTION")))
|
|
#
¿
Jul 26, 2011 21:06
|
|
|
Is there any reason why it has to be the top Google result? If you were to make it the wikipedia page, that would probably be easier. Also, in most cases, it probably is the top result anyway.
|
|
#
¿
Aug 19, 2011 23:56
|
|
|
|
| # ¿ May 14, 2024 04:05 |
|
|
Carbon Deity posted:OK, Gentlemen, let's see if somebody can help me tackle this. That doesn't sound too difficult. Unless I'm missing something, you can just use an IF function. If you enter the following into your sheet two cell, assuming that your data is in column A of sheet 1, it should work: =IF(Sheet1!A1>0,Sheet1!A1," ") So, if sheet 1, column A has an entry, it will be displayed in sheet 2. If not, it will just be blank.
|
|
#
¿
Nov 9, 2011 18:03
|
|