Running Excel 2003 (11.6560.6568) SP2.
目前分類:title (4957)
- Aug 07 Thu 2008 20:45
Displaying formula rather than results...
- Aug 07 Thu 2008 20:45
Excel User Conference
- Aug 07 Thu 2008 20:45
Confusion...(conditional formatting)
- Aug 07 Thu 2008 20:45
xls spreadsheet constantly calculating causing navigation issues
Sytem details - Office 2003 - Windows XP - Bloomberg Installed adn running
- Aug 07 Thu 2008 20:45
IF function
I'm trying to get excel 2000 to return one formula if something is true and
another if it's false. This is what I have so far:
- Aug 07 Thu 2008 20:45
I need more general XY point to point plotting than XY scatter in
I want to connect two sets of XY points (in four columns) with line segments,
and show the entire set on one 2D plot. XY scatterplot is frustrating because
- Aug 07 Thu 2008 20:45
Count Unique Entries
I am trying to count unique entries across a set of colums. For example,
A C
- Aug 07 Thu 2008 20:45
Charts
When using a routine to re-size charts, the font size in the X and Y axis
lock and changes to size 1 and what ever you do cannot change this up, why is
- Aug 07 Thu 2008 20:45
Concatenate and keep preceeding zeros
I have tried everything to convert 5 columns into a single string. The
problem is that these cells contain preceeding zeros, and when I try to
- Aug 07 Thu 2008 20:45
using data from ascii file?
I know how to get my formulas to pull data from another workbook... but what
if I want it to pull from an ascii, comma-delimited file? Then I am not sure
- Aug 07 Thu 2008 20:45
How do you multiply each cell by the same number? ( 899.80*.085)
i am having to convert dollars from a annual base to a monthly base and I
need to know how to change each cell to the product of .085.
- Aug 07 Thu 2008 20:45
Can I reference the min and max values of an axis to a cell?
I'm trying to dynamically create some charts that move by date. I would like
to also be able to change the scale of the axis. Basically, I want the max
- Aug 07 Thu 2008 20:45
not following your answer
Dave Peterson: A couple of days ago you sent a response to me that I have
worked on since then. I am still not sure where I am going wrong. The part
- Aug 07 Thu 2008 20:45
lookup/index/match
In the following I need it to return the quote/price that falls into the
appropriate date range for a specific part number.
- Aug 07 Thu 2008 20:45
What is the formula for calculating the number of months passed?
I need a formula that looks at dates and calculates the number of full months
from one date to the next. Can anyone help with this?
- Aug 07 Thu 2008 20:45
Shared workbook issue???
Hi all... I am back!
I recently shared workbook, and have noticed 2 problems. I can not insert
- Aug 07 Thu 2008 20:45
Printing what I can see on the screen
On a monthly basis, I need to generate a simple 10 line report from a
very large spreadsheet. Using the Subtotals function under the Data
- Aug 07 Thu 2008 20:45
Why can't I undo forever in Excel like in Word?
When I am working in Word, I can undo as manny actions as I have performed,
as long as I don't save the actions. However, in Excel, I can only go back
- Aug 07 Thu 2008 20:45
Shifting Calculated Result
First of all let me wish a happy new year to the group. I appreciate
everything the group has done to help... and it has. Her is my recent