I have found that if you try to "group" a ninth level (via pick-n-click,
macro, or VBA), Excel doesn't complain or give you an error, it just ignors
your command and will not group any further.  Is there ANY possible way to
get around this limitation?  I am tracking mass ...

In a column I have three possible values, A, B or C.
I'd like to be able to construct formulas which count the number of
times each value occurs, so that I could then have three cells showing
total occurances of A, total occurances of B and total occurances of

While I'm here...
I have never been able to get Excel to calculate time totals instead
of treating time values as times of day.
I'm currently keeping a time sheet; I enter the time I start and the

I have a spreadsheet with multiple tabs. The first tab tallys numbers from
other tabs, and compares them with data on the first tab. ex: tab1- tab6. In
tab1, I have a cell, lets say A1 where I need to add tab2-a1, a2, a3 + tab3-
a1,a2,a3 (and so on up to tab6). Then once those ...

Not a very knowledgeable Excel 2003 user, but - I am trying to lookup a value
from column B2:B415 in worksheet 1 and trying to find the matching value in
worksheet2, column A2:A415.  I would like the value in the next column in
worksheet 2 to be returned to the column in ...

I know everyone is looking for latest version, but I work as a developer and
my customer use Excel 2000. He asked me to evaluate the cost of an upgrade to
Excel 2003, so here I am.
My program must fill 5000*255 cells.

I need to create a formula that acts like a combination of a SUMIF and a
VLOOKUP.  I thought a DSUM would work, but haven't had any luck.
I have 2 sheets.  The first contains Account numbers in the first column,
then 12 further columns for each of the months, containing dollar ...

Is there a function that will pick out  numbers that are almost the same they
just have a .0001 of a difference between them.  I have 2 figures that are
reading 15% but they are actually 15.447 and 15.449 therefore the MODE
function is not recognising them as the same.  and i ...

Dear Sir,
I was working on a large Excel file of around 12.5 MB today.
This file has many pages and with a lot of formulas in it.
When the "Freeze Pane" function was on, I tried to sum up around 50 rows of

Only at www.medicalschoolloans.com, do candidates get flexible payment
opportunities, low monthly payments, and reduced interest rates.  No
other lender can be as flexible.  Best of all, there are no
consolidation fees.  There is no reason not to consolidate now.  Sign

When I click open an excel file (from File folder), it automatically open 2
blank excel workbooks and then open the file I selected.  
I could not find anywhere in the Help section that answers this.  If someone
can help me, I would very much appreciated.

I have a workbook with 5 worksheets on my local drive.
I want to send shortcut to One of the Worksheets to my desktop, not the
whole workbook.  Also, when i enter information into the worksheet, opened by
the shortcut, i would like it to update the original sheet in the original

I have a code that opens an existing excel file but, if someone is already
in the file, it does not pop up a window that says which user is currently in
the file.  Can some add to my coding so that when the file is opened and
someone is in the file it will identify who is in the ...

I have a table set up and would like to copy the cells to another worksheet,
creating a different printout for each row's cells.  How can I set up the
worksheet to use the contents for just row 1, for example, print out my
results, and then move on to row 2?

Using Excel 2003, I have placed a hyperlink in a cell.  No matter what I do I
can't conditionally format the hyperlink text.  I have even set the
condition:  Formula is true.  Which means that as soon as I press ok, the
formatting should occur immediately.  This works for any ...