How do I subtract a calculated column from another calculated column an
have it show on the Pivot tabl
--
ceunic

I have a worksheet that has products listed that are on sale at different
times of the year. My question is what formula to use to get all Jan
products,codes,prices etc on to new worksheet, Feb on another worksheet etc.
Thanks

Is it possible in Excel (2003) to have a LH scale and a RH scale when
charting?
For example, in US terms, a LH scale showing Dow Jones Index (say 9000 -
12000 points) and a RH scale of a particular stock (say MS, $15 - $30) over

When I enter a number in a cell, like a serial number with 16 digits, it
always makes the last number a zero even when it isn't.
For instance I will type 23467923400998
but it will show            23467923400990

Does anyone know of a way to group a text box to a data point in an
excel chart? I am unable to click on both items to use the Group. If I
add x axis points, the text box is no longer near its point. If this is
not possible, I'd like to know that too.

I need only 30 rows, 7 columns in my worksheet, and I don't want more
rows and columns to be present, even the row/column indicator at the
left/top of the view (i.e. I don't want to see 31, 32, 33,... at the
left border or H, I, J,... at the top).

Easy way to bring a worksheet from one workbook into another workbook?

People,
I have an eMac running OS 10.2.8 with Office 2004 for Mac installed. I
applied all the latest updates for Office.
I am trying to create a header for an Excel worksheet. When I go to

(Sort of a novice, so try to keep it at my level, if possible)
In my spreadsheet, I am comparing calculated results to an "acceptance
value."  If the results meet the "acceptance value" I want the cell to
display "Passed."  If not, I want the cell to display "Failed."  Using the

I have an excel spreadsheet and I want to lock portions of it ... not all.
Can that be done.  Locking alone doesn't work, but protection locks the
entire worksheet down.
How do I beat this?  Thanks.

I have been developing in Excel/VBA/SQL for 10+ years and have a little
VB.NET.
I have a pretty good - but certainly not great - understanding of OOD &
OOP.

hello all..
wondering if there is any way to do this...
I have a column formatted for time as in this format 12:00
when entering a time it is cumbersome to have to enter the hour, then a

At the bottom of a couple thousand rows of data, I have =MAX and =MIN
formulas.  Is there some way I could make the cells beneath my MAX and MIN
formulas show me the address of which cell has the displayed MAX or MIN
value?  At least the row number?

I have a team budget with several worksheets. One sheet has salary info and I
need to keep the confidential (for me only). But I would like to let other
team members look at and edit other worksheets (ie costs for projects they're
managing). Can you recommend a method for this?

I'm trying to generate a random lognormal distribution of stock returns
where the mean return is 6.5% and the standard deviation is 20%.
Previously I've done this with a normal distribution, using
NORMINV(RAND(),mean,stddev). However, since stock returns tend to be