Each cell in column A contains multiple entries separated by a comma and a
space (e.g., P7899, P7899.7, P9250, P9261).  Ideally, I would like to use a
built-in function (versus a custom function if possible) that extracts the
contents of each cell in column A and puts the ...

I forgot to tell you it is tonite, 7 - 8 pm.

I'm trying to use this new  worksheet function, using the example provided
in the online help, but it doesn't work asbsolutely... The only way I
succeded was using it like a regular SUMIF...
I think it should be some bug in this function...

I have figured out how to get drop downs in my spreadsheet but I can not
figure out how to be able to re-use the same one in different boxes over
again.  When I put in a selection from a drop down, it takes it away from
being one of the choices on my list for the next one.  I ...

Hey all,
    I've got a column of equations [=IF(B3="S","3","")] that gives me 3's
in each cell.  When I go to AutoSum the column, I get a "0", not the
total of 3's.  This should be really simple.  I want to add up what's

Why does the "Do you want to Save Changes you made to [filename.xls]?"
appear eventhough I didn't even enter a single keystroke, there aren't
any modules attached to the workbook, no private subs in the worksheets
and there aren't any calculation upon opening the file?

On my worksheet there's one cell (let say A1), and A1=B1/C1.
And I want to create a function in cell D1 which will return the
numbers with the following conditions :
If 0<A1<=1 then D1=70%

I need a formula for the below:
if a1 is greater than zero or a2 is greater than zero and a3 is zero
then "footnote A"
I have been trying If formulas with And and I can not seem to figur

In creating a CSE formula the asterisk is used for AND... for example:
sum(if((Code="test")*(Acct="Recon"),Amount)), where Code, Acct and Amount
are ranges.
What sign is used for OR?  What I'm trying to do is sum the values in the

I have a graph with data for this year and last year by month.  The data for
last year by month has already been pre-populated and the data for this year
is added each month when it is available. Every month when I add the data for
this year, I have to manually expand the data ...

I have a spreadsheet that contains names of groups and numerical results for
them as below.
Column A                   Column B
Frame                            .50

I was wondering if the is any way to vary the cell shading color and/or font
color based on the cell shading color and/or font color of another cell in
the same sheet.  I am trying to set up a sheet that shows whether we have
received a report from a facility and I have used ...

Have Excel 2003.  Can not get the Automatic Subtotal in a list function to
work.  
When I select a range of data (labels) within my table, the menu command
Data - - Subtotal is "greyed out".  If I select data on the same worksheet,

I've done this before but can't remember the solution.  I have two columns of
date: Column A contains first names, Column B conains last names.  I created
column C for the combined contents of A and B.  I also want the data
separated by a space.  I understand that if I want to ...

Excel does not seem to handle such a large number of data points.