I'm trying to determine the length fo time ( in days) that we have owned
pieces of equipment.
目前分類:title (4957)
- Apr 13 Sun 2008 20:43
calculating days
- Apr 13 Sun 2008 20:43
Delete 4 to 5 digits from left in a cell
With data in A1, in B1 put=TRIM(MID(A1,FIND(quot;:quot;,A1) 1,255))
- Apr 13 Sun 2008 20:43
New Help in Line Chart
- Apr 13 Sun 2008 20:43
how to plot an XY chart with labels specified by separate column
I want to plot a simple XY graph with data labels on the chart supplied by a
column different than the data used to plot the data points.
- Apr 13 Sun 2008 20:43
I want to do a workbook with dates and times
I want to do a very simple workbook with dates of meetings, each day in the
month, with times of meetings and the text of who the meeting is booked for.
- Apr 13 Sun 2008 20:43
Multiple or Variable cell references in Solver (Excel 97)
I'm using solver to find the optimal price by returning a margin of 0.
Because I need to repeat this for several hundred prices, I have been trying
- Apr 13 Sun 2008 20:43
Reducing a size of the shared excel file
Hi everybody!
- Apr 13 Sun 2008 20:43
excel type lower displays upper
I have spreadsheet someone set up when you type lower case it displays
uppercase. How can I turn that off?
- Apr 13 Sun 2008 20:43
How to merge rows?
I need merge rows. How to merge rows?
- Apr 13 Sun 2008 20:43
How do I find columns that I covered up?
I moved column M next to column E so that I could see them better side by
side, but I lost colums F-L in the process. I know the data is still there
- Apr 13 Sun 2008 20:43
If I have Word 97 is Excel included with it?
Hi,
I have the Works Suite 99 Disc 1- which contains the following : Microsoft
- Apr 13 Sun 2008 20:43
Excel, Formatting Cells
How do I format a cell to divide the $ into the next cell for a 50% price
differnece?
- Apr 13 Sun 2008 20:43
Mortgage calculations
I need a formula to calculate the payments based on loan amount, interest
rate and term of the loan. This is for mortgage payments
- Apr 13 Sun 2008 20:43
Labeliing of Bar graph in X axis
I have a simple bar graph with the Y- axis measuring vertically in units and
the X-axis a series of bars that show month 2004 then same month 2005
- Apr 13 Sun 2008 20:43
Can I get current #row or #column in cell formula?
For example, I freeze pane for row 1, and want A1 cell to display quot;Text1quot;
when windows is scrolling within row 2~100, and display quot;Text2quot; when it's
- Apr 13 Sun 2008 20:43
Creating Error pop ups
- Apr 13 Sun 2008 20:43
Here is fix for Windows file problems
If you have installed a Windows update and started having problems opening,
closing, copying files, see:
- Apr 13 Sun 2008 20:43
Counting dates in multiple work sheets and work books
I have 12 workbooks that divide up each of our branches with work sheets for
each employee. What I want to do is count training session completion dates
- Apr 13 Sun 2008 20:43
sumproduct returns zero
The following formula gives me a zero result :
=SUMPRODUCT((B2:B18=quot;joequot;)*(F2:F18gt;quot;0quot;))
- Apr 13 Sun 2008 20:43
how do I filter data and put in a new worksheet
I have a worksheet of outstanding invoices. I have a column that calculates
how old the invoice is (i.e. 30, 60, 90 days overdue). I want to create on