I have a scheduleing program we have been using with my buisness for years
and I am adapting to it, to make it more efficent.
I want it to be able to count how many days a person works, so we don't have
to count each day ourselvs.

Consider the following examples of the same Sumproduct formula all similarly
constructed:-
=SUMPRODUCT(N($A$1:$A$20="This")*N($B$1:$B$20="That"))
=SUMPRODUCT(($A$1:$A$20="This")^1*($B$1:$B$20="That")^1)

I have a wks for the description of stock items but the description is in 40
character groups so for one item number I have multiple rows, I need a way to
merge these rows into one cell per stock number.
example

I have a list of agents in row A (about 3000) and may of them are duplicate
values (sometimes the same agent name is there 5 or 6 times).
Can I do anything to delete the duplicate rows keeping only one row with the
value in question (formula, macro, etc.)???

How do I change the default behavior of the Find & Replace dialog box to
Search by Columns versus Rows?

I currently have a workbook with 7 sheets.
One called Main and the other are named with the weekdays names
(monday-saturday)
Each sheet has on top a pie chart showing the number of fruit sold

I have a display as such
A    B            F        G
FRED    YES            FRED
JIM                 JIM

In the old days (2003) you could right click a field, select properties, then
hit advanced and you could tell how you wanted to sort the field data in the
Page Filters of a pivot table.  I can't see how to sort in Excel 2007 --
Any help would be appreciated . . .

Is there a way to state a criteron range in an advanced filter? I cannot
figure out the syntax if there is. Please see below on the filter as I have
placed a "Range" in the filter that obviously doesn't work but is there a way
to make it work?

I've been using CONDITIONAL FORMATTING to fill cells in visually
illustrating a rectangle based on a length and width using the following
formula:
=AND(COLUMN()<=16,ROW()<=24)

hello
I have 2 columns N&O N:the Yield and O: How much I have in that security.
everytime I add a new security I add a new row and I fill it.
However, I have a cell at the end of column O which I have to add manually

In Excel 2000, is there some setting I've not yet found that will
prevent messages like this appearing every time I try to save a file
please?
"xyz.csv may contain features that are not compatible with CSV (Comma

I'm triying to sort letters and numbers together like ch5600,ch74110 and so on
but when I try it doesn't sort in scending sequence
ch441
ch445

Hi - am currently using Excel 2003
I really appreciate any help on this. I am using a master worksheet (new) to
create and copy to other sheets and am using macro to auto update tab name
from cell A2 - this works great.

I have 5 cells in a row (A1 - A5).  I need to subtract, in military time, A1
from A2 and then A3 from A4 and the total should be in A5 as standard time.  
Cells A1-A4 are formatted as hhmm and cell A5 is formatted as hh:mm.