目前分類:title (3013)
- Dec 18 Mon 2006 20:34
highlighting rows according to a input value?
- Dec 18 Mon 2006 20:34
Last row value to another sheet
On one worksheet, I have several rows. Each time a new row of data is added,
I need to take the value from column B in the last row and display it in a
I need to take the value from column B in the last row and display it in a
- Dec 18 Mon 2006 20:34
Pivot table problems
I'm trying to create a pivot table and I'm having problems with 1
field. The error message reads:
field. The error message reads:
- Dec 18 Mon 2006 20:34
Numbered Lists
- Dec 18 Mon 2006 20:34
Comments in Excel saved to HTML
Created a workbook that I saved to HTML. The comments that were created for
certain cells now show up with the comment indicator changed to a numbered
certain cells now show up with the comment indicator changed to a numbered
- Dec 18 Mon 2006 20:34
Formula to find highest alphabetic name in a list of names
- Dec 18 Mon 2006 20:34
Running Schedule
I have a running schedule with mutlile tasks scheduled for different day # or
the same and would like to have the dates auto fill in once I enter the start
the same and would like to have the dates auto fill in once I enter the start
- Dec 18 Mon 2006 20:34
Prevent Username Accessing Workbook
I have a shared workbook which is used by several people. I would like to
prevent one particular username (the one set it Excel properties) from
prevent one particular username (the one set it Excel properties) from
- Dec 18 Mon 2006 20:34
Excel ? Formula for moving average
- Dec 18 Mon 2006 20:34
how to use the IF formula with a range of cells
I have a text in one cell (J2) and have to compare it with text in a range of
cells (B2:B999) to return an expression if true. I have tried using the IF
cells (B2:B999) to return an expression if true. I have tried using the IF
- Dec 18 Mon 2006 20:34
cHARACTERS BEFORE THE SPACE
- Dec 18 Mon 2006 20:34
Excel file window won't open
When I open my Excel software I can't open the file listing window. The
program hangs up and does not respond. The same thing happens with Word.
program hangs up and does not respond. The same thing happens with Word.
- Dec 18 Mon 2006 20:34
Criteria problems in the DSUM function
I have an excel sheet with three worksheets.
1. Database from which the final values is looked from (quot;NetDataquot;)
1. Database from which the final values is looked from (quot;NetDataquot;)
- Dec 18 Mon 2006 20:34
counting
- Dec 18 Mon 2006 20:34
excel chart and data don't match, help
I have a large spreadsheet and when I try to plot columns in a scatter plot I
don't get what is in the columns. For example this is what you get when you
don't get what is in the columns. For example this is what you get when you
- Dec 18 Mon 2006 20:34
Access to Excel problem?
- Dec 18 Mon 2006 20:34
MROUND on a negative number.
I came up with the following formula all by myself !!
=IF($I$2=quot;NOT TRANSFERREDquot;,$K$21 $K$22,MROUND($K$21 $K$22-$K$23-$K$24,0.25))
=IF($I$2=quot;NOT TRANSFERREDquot;,$K$21 $K$22,MROUND($K$21 $K$22-$K$23-$K$24,0.25))
- Dec 18 Mon 2006 20:34
DIFFERENT NAMED CELLS IN COLUMN,HOW DO I GET LAST ONE ON BOTTOM?
i have a column with lots of different informatio in them ranging from dates,
but I want the last cell to be at the bottom and have it update automatically
but I want the last cell to be at the bottom and have it update automatically
- Dec 18 Mon 2006 20:34
how do you do co-integration chart
I was wondering if anyone could help me out with cointegration charts in Excel.
Thanks in advance.Hi,
Thanks in advance.Hi,
- Dec 18 Mon 2006 20:34
How do I create a required password before opening an excel doc?
I am trying to protect my excel spread sheet doc, where it will require to
enter a password prior to opening the document, each time someone wants to
enter a password prior to opening the document, each time someone wants to