is there a way to turn off the auto-subtotal when using pivot table fields? I
turned of the grand totals, but I still end up having to double click on the
column name and choosing none from the subtotals for every column.

Column I has this formula: =IF(AND(H173>K173,AH173<0),"Past TAT","")
Column H also has a formula that sums days.
=IF(OR(Y173<>"",W173=""),"",TODAY()-W173)
Column H is working and producing no days as required. However, the formula

Can I specify a formula where I highlight the entire row if one cell contains
the word "auto-renew"?

First post!  I hope this is the right section!
I need to calculate a simple average (arithmetic and median) of a set
of numbers, but excluding certain outlying points.  I'm not by any
means a newbie to coding so I do know how I'd do this generally in a

OK, it's no sweat to do it manually (which I do now), but curiosity is
making me wonder if it could be done automatically without being too complex
What I have now is a list of players with golf scores, a summation of the
four rounds of scores, and a rank function which ranks only ...

Using a spreadsheet I need a chart that would return the answer across the
rows.
Where the total is equal to the starting number. To answer how many lessons
can be taught each day to achieve the goal per week. My problem lies in that

I'm having a problem figuring out how to combine TWO functions to work
properly.  What I'm trying to do is the following:
My chart looks like the following
B        C            D         F      G        H            J      K

I have a list in a spreadsheet as follows. I want a formula to fill the Criteria column. The condition should be
 a.. Invoice dollars should be less than $ 200 and
 b.. if there are two Invoices for the same customer and if the sum of all Invoices is still less than $ 200, it ...

I need to use three colors with multiple conditions;
green = 5.6-6.0 or 6.1-7.0
Yellow= <700 or >900
Red= 1.1-3.8 or 2.0-5.9 or 5.0-6.9

I am doing a lookup from one workbook to another and there are multiple
rows that match the lookup value. I need it to return the highest value
only from the second column. Suggestions?

First post!  I hope this is the right section!
I need to calculate a simple average (arithmetic and median) of a set
of numbers, but excluding certain outlying points.  I'm not by any
means a newbie to coding so I do know how I'd do this generally in a

In COlumn A I have have ten colors (red, blue etc.)
In Column B i have ten reandom numbers (12, 54 etc)
What I want is this:
On a separate sheet, it takes a random color from column A and joins it

Excel 2003 does not allow me to work from a pivot table in the same way Excel
2000 did.  When pointing and clicking to a cell in a pivot table, the formula
is returned as "get pivot data" and actually goes to the pivot table data,
rather than the cell that I have clicked.  I am ...

Hi, im making a worksheet for our shooting results. I need the average of the
top 3 results from collum E6 to W6 and top 3 reults from Y6 to AJ6. Can
anyone help me with this one??

Hello all I'm working on a spreadsheet with the fol formula:
=IF(VLOOKUP(C4;Appartment!$C$1:$C$63;1;FALSE)=C4;"Double";"")
I would like to and an OR in there that it would lookup and other columie:
(B4;Appartment!$B$1:$B$63;1;FALSE)=B4;"Double";"").