In Excel 2007, I have discovered a SUBTOTAL function anomaly when filtering
records. I have headings in row 2 and data in rows 3 through 27 with costs
in dollars in column K. In K2 I enter the formula =SUBTOTAL(1,G3:G27) which
produces the answer $15.76.  There are records for ...

How can I do this (below) in 2007 Excel?
I have a list of high school course codes for some college classes in
Column D. In column E I would like the NAME of the class, but I do
NOT

I am a newuser in excel, i need help with calculating percentage with
2 different cells.
from cell a1 i want to take 70%, from b1 i want to take 30% out of a
dollar and want it to display in c1,

I see that I only get the option to group items from a number to a number
when all my data is numeric.  Problem is that because I don't know how many
rows my data will have (I want to be able to paste in new values and just
'refresh' the pivot table), I have used the source "$A:$H".

I have a pivot table showing counts of grades achieved by students.
I can group some of these grades by adding a calculated item that just adds
together the number of, say, grade As and grade Bs.  This seems more elegant
than the outline and grouping feature.  So far so good.

I came upon an excel issue that, performing a web search, I do not
find documented anywhere.
When decimal numbers are displayed as fraction using Format-->Fraction
(up to one digit), Excel selects the closest available fraction

I need the formula to multiply by 3 diferent rates base on the following
assumptions if a<10,000,a*0.08,if a>10001,a*0.06, if a>20001,a*0.04. can
anyone help ?

I store Function in a table such as:
=HYPERLINK("www.google.com","Google")
But when I connect to the data source and display it - it actually displays:
"=HYPERLINK("www.google.com","Google")"

I am building a simple work book My first row where my titles need to be are
2 rows tall to enter my data. Typing always starts at the bottom left hand
corner I want typing to start at top left corner so I can enter my 2 rows of
data??

When I open Excel, I get this error message.  I don't know anything about
programing, I am just a user.

If somebody could help me with this I would be very happy, I can't figure it
out:
In a sheet I have a column of figures to which new figures are added regularly.
At the side of the column I'd like to have a cell containing the last number in

Hello
I receive numerous excel spreadsheets from vendors. Each provides
distribution by state, but not all vendors distribute in each of the 50
states. I enter the spreadsheets data into one spreadsheet to obtain total

Is there a way to set the width and heighth of a cell in inches?
Thanks, Debbie

Hi. I used a macro once, when someone from here helped me. Sorry to say I
can't find my original post or document. Can someone with this:
Need a macro (it was vb last time)
To search a column and remove the double quote. It will always be in the

Using both Excel 2003 and 2007 (different machines)
Example of what I am trying to do.  I have a list of people's names and
dates they are scheduled to volunteer.  First name is in Column A, Last Name
is in Column B, Date is in Column C.