View Single Post
Old 10-03-2011, 07:53 AM   #1
byou678
Member
 
Location: Maryland

Join Date: Aug 2011
Posts: 52
Question How to extract Common Genes from 2 spreadsheets

Now I have two Excel spreadsheets, parts of them are as below:

Spreadsheet1

Gene Change Padj
1 212 0.0006
2 99 0.09
3 15 0.7
4 59 0.456
5 418 0.00001
6 566 0

Spreadsheet2

Gene Statistic FDR
1 28 0.0005
2 17 0.007
3 3 0.81
4 8 0.28
5 48 0.002
6 111 0

Using Excel, how can I create one new spreadsheet that only includes the
Genes with both Padj and FDR are less than 0.05?

And how can I do this in any other statsitical software, Like R, SPSS?
Thanks very much for any idea for any question!
byou678 is offline   Reply With Quote