I've been trying to figure this out for a while now. I dont want to us
a pivot table if I can help it.
Say I have a spreadsheet like this:
Colour,    Type

I am working on a median formula as follows
=MEDIAN(IF(OR(Data!$D$2:$D$29998=MCalcs!$A$11,Data!$D$2:$D$29998=$A$12),(IF(Data!$F$2:$F$29998>=MCalcs!B$7,(IF(Data!$F$2:$F$29998<=MCalcs!B$8,Data!$E$2:$E$29998))))))I have 10 product codes with monthly sales data,  The worksheet Data ...

We are creating an aging report from excel.
Criterias are (days):
1.  0 - 30
2.  31 - 60

This Is something I was looking forward to in 2007,  Unfortunately
Conditional Formating Is Still Bound To One Sheet... as well as not
being able to lock/unlock multiple sheets unless you're running a
macro...:confused:  Still Have to Copy and Paste in Most Instances to

Hi again !
Another simply one I hope:
I have 2 columns of data
Country               Band

Is there a keyboard shortcut for "protect worksheet" function. I have a
workbook with 45+ sheets which needs to be individually protected, as global
protection is not possible. It become a bit laborious to move up and down
with your cursor, between the protect worksheet icon in ...

How can I make it so not only the values in the cell but the formatting
to that cell is referenced as well.  Take for example I have a number
"22" in a cell, but it is bolded and italicized as well as centered.
Is there a way to copy these formats over as well?

Goodmorning everyone,
I've got a problem:
I have 7 rows to deny ALL users to select and change them.
Then 9 rows to deny users to change them, but allow for SOME users to

I cut pasted some data in workbook sheet  A from another workbook sheet
B and then deleted workbook B.
When I click on the cell it refers to workbook B, in fact gives me the
full path of the value. The file is no longer there. I cant find it

  I have a spreadsheet where column 'A' is a long list of values which is
either a blank cell or the word 'FOUND'.
Is there a way of displaying in one cell up the top, for example B1 which
can contain all the cell references where the word 'FOUND' is listed, e.g.

Each time I open any of the workbooks I created, an anti virus scan takes
place.  I know they are virus free and have been for years.  I am the only
one who opens them as there are no other users of the machine.
Is there a way to disable the virus scan (AVG) for each workbook?

With these functions they find the highest value which is less than or
equal to the lookup value. For example
A      B
1      30

Hello, don't want to be pest on my Duplicate Questions, but I was hoping
someone could give me a shorter formula for the one I have here.
I have 31 sheets representing 31 days (DAY1 - DAY31), of the calender
in which I check for dupes in the Phone Number Column E6-E35 in all

I able to find the Min and Max date from a Range of Dates. However, I would
like the Min and Max date for a range of facilities -
Data
Facility 1   12/21/2005

With due respect, 2007 did include many improvements..  Faster
editing/formating, extended conditional formating, better wizards,
etc..
Be aware that some of the formating may not be compatible with 2003