I usually have to compare list of genes to find out which genes are common
in the lists, so I usually use http://jura.wi.mit.edu/bioc/tools/compare.html
But wondering how do I do it if I have got more than 2 lists.
Also, is there any way that I can compare these lists in the ...

I have a spreadsheet where I need to link cells from 1 worksheet to another.
Worksheet DHL needs to link with cells on worksheet Box Label.
I have linked the 2 worksheets with the following formulas.
B2   =IF(DHL!C5="","",DHL!C5)

I understand most of the formula from the response to my original posting
(see orig posting and response below) except for the following:
MATCH(B4,OFFSET(Table2,1,1,,1),TRUE)+1
How does this find the row where the age in Table 1 is between Age_lower and

I have a pivot table that gives me customer name and the month he last
bought an item and the month he first bought an item, the max. value
of the item he bought as well as the min. amount and the category of
item(books, apparel, electronics). I want to create a list that reads

I'm interested in doing an if equation that will have a statement inlcuded
in my false answer.
I.e.,
=if(a1=e1,"ok","Amount short by: " a1-e1)

Newbie here.... working on a spreadsheet that we need to enter times that we
receive faxes from our 3rd party... we enter times in this format 3:30 is
3:30 pm.  the workbook is shared on a network there are several people
entering data at one time...  what i need to know is can i ...

I have to do a complex lookup.  Here are the excel tables involved:
Table 1                       
Name    Age    Status               
Jim    25    MNS               

I have until the end of the day (5pm est) to resolve this issue!
Now that I have your suggestion working I have a followup question:
I select "Agency" in H1 that allows input into H2
I put in "4.5", which reads as $4.50

I want to use the IF function, but using a Logical Test on a given cell that
contains text, like 'Red; Green; Blue'. The cell may contain all, none, or
any of these words. If the cell contains Red, I want to Return Yes
My Function would look something like

How do I go about averaging the following?
Cell A1 = 3 min. 3 sec.
Cell A2 = 1 min. 13 sec.
What formula would I use to average the two?

In cell A1, I have a formula giving me a number 31.
In cell B1, I need to enter text saying "30-35"
This formula needs to change based on the content of cell A1.  For example,
if A1 said 20, then B1 should read "15-20", if A1 said 67, then B1 should

when working in word in an excel spreadsheet and typing in a column, and a
sentence extends to another line, how do I keep the next line word from
beginning with a capital letter?

I am interested in a function returning a simple calculation concatenated w/
text, but would like the format of the returned caculation to be a
percentage.  
ie.

Is there a way to find or select cells containing a volatile formula?  The
formula could be used explicitly in the cell, or may be substituted by a name
whose definition contains a volatile function.

When I opened the new spreadsheet i am seeing by default the column names
has been changed to the numbers.  Now I need to bring it down to the
Alphabets back.
Could you please let me know how to change the column names from numbers to