I need to creat a chart that starts out with measurements in cubic
centimeters and need a formula to convert to ounces when there are enough cc
to equal an ounce.

I am trying to create a budget.
The desire is to have "summary" lines for each section and then be able to
click on the summary line and see the detail - a drill down to the detail.
Can this be done.

How can I convert a date like this 01/12/06 into one that looks like
this Jan-06 so that a sumif or lookup will get all dates that fall in
January of 2006. Formatting does not do it because the functions still
reads it as 01/12/06.

I am attempting to include a footer on excel printouts that includes the path
name so I can later locate the file.  Many users.  Many with dissimilar drive
mappings.  The current path name is coming up as j:/john/worksheets.  Whereas
that works for me, that will not work for ...

I'm trying to come up with a formula that would give me a count of a yes/no
combination in two different columns like below:
        K               L        
1     Member    Approved

In order to save word processing time, I like to use the "=" sign to
replicate text in a cell from one worksheet from a cell in another worksheet
. Sometimes this function replicates text properly in the cell; sometimes it
justs replicates the formula in the cell. How do I get it ...

I would like for some calculated results from cells in one worksheet to
automatically be entered into similar cells in a different worksheet.
As it stands now I have to transfer the data by hand each month, making
the data much more susceptible to error. How can I do this? Thanks!

The cell contains a formula to determine the contents.  Based upon results, I
would like to color the background of the cell (e.g. if >10 color red; if >10
& <20 color yellow; etc.).  I have not been successful in finding a solution
using help.  Thanks!

Is there any way to have 2 functions in one cell?  I have a =sum function in
a cell and i want to round that value from that function can it be done?

I have an application that I wrote a while ago that is having a little bit
of problem with bogus data being given to it.
The input is a tab separated variable file, where every record of data
should have the same number of tab characters.

IIs  there a way to sort my table by Row1 ?
    ColA    ColB    ColC    ColD    ColE
Row1    8293    87177    34467    36028    65796
Row2    BOX549    BOX917    BOX642    BOX980    BOX919

I have a column B of names that is part of my sumproduct formula...there are
some cells in this column that contain #N/A.  I have to be able to complete
the sumproduct formula by ignoring these errors... Is there something I can
add to the sumproduct formula to ignore these ...

OK, maybe there's a better way to do this, but I have the Colorindex function
(from Ozgrid, I think) and I want to get the maximum value over a number of
cells:
I have something like this:

I want to export a query from Access to Excel and then analyze the data
What I'm pulling into Excel is data with 31 columns.  (30 are audi
questions and the last is the name of the person being audited.)  
Row 1 is a header row, showing each question's description.  (i.e

Hi,
I have a table like this:
A               B          
Name    January