1)  I have 2 fields in the Row section of the Pivot Table.  Is there a way to
set it up so you don't have a total at the end of each value change in the
first field of the row section?  I dont want any subtotals totals; just the
grand total.

I'M LOOKING FOR A DAILY MEDICATION DOSAGE TEMPLATE FOR ONE MONTH AT A TIME.  
IT SHOULD HAVE AT LEAST FOUR TIMES DAILY TO LOG DOSAGES.

I need a formula to do the following:
If I2:AV2 = "Sht In Form" and I3:AV3 = "YES"
If I2:AV2 = "Sheet Present" and I3:AV3 = "YES"
What I really need is to count when the first set intersects the second set

I am using the following
=SUMIF(Taken!A$1:A$1999,Accrual!C6,Taken!D$1:D$1999).  When I do a sort on
the data the Accrual!C6 remains cell C6 but it should be C10 because I added
information and then sorted and the formula is now on line 10.

I am trying to create a spreadsheet to help with medication inventory. I want
to have the cell change colors at different intervals to correspond to
different dates to give me different warning levels. For example, if a
medication is to exipre within 30 days, I would like the ...

Is there a limit on how many cells in a worksheet can contain an array
formula.  My sheet seems to cap out and not allow me to copy the formula down
after a certain number of rows.

I was trying to use the Match function in a VBA module (I hate VBA).  
Match was failing unexpectedly.
I evenetually tracked down one issue (using Match in a normal worksheet
not in a module).

Is it possible to position a PAGE NUMBER on the side of a sheet?  If so, can
I position it sideways.  My sheet is landscape and I want the page # to be
position on the left side horizontally.  Thanks

I need to set up a spreadsheet that will flag me when it is 21 days past the
date I input originally.

I need to look up information using multiple variables, one of those
variables using a range. I want the associate number returned based on where
they fall in the sequence and batch number. The following is an example:
SHEET ONE:

I am using the Beta Office 2007 and when I'm working on my spreadsheet to
enter data which has macros, it will work fine for a few minutes, then I get
an error which says Method 'Activate' of object 'Range' failed.  Then I have
to shut completely down and open Excel again.  Can ...

I have 2 worksheets that I want to group and copy.  In Excel 2003 when I
select the 2 worksheets and create a copy I'm prompted to create a new name
for the reference cells so the formulas don't refer back to the wrong
worksheet, in addition the grouped worksheets have formulas ...

I want to have an if( statement evaluate a cell and see if it contains a
certain text word or phrase, anywhere in the cell, and if so perform x , if
not y.

Educational use:
Using excel to set pupil targets. Each target level is subdivided into three
sub levels.ie Level 3 a,b,c; Level 4 a,b,c etc.  Is there an excel formula
that could automatically raise a level/sublevel by a margin of two, ie raise

I need to change the color of the font in a cell that equals my true value
and my false value needs to stay the same.  ie, if overbudget, i need the
cell color to be red, if at or underbudget, i need the cell color to stay
black.  Is this at all possible?