I have a workseet with 3 columns:
Date           New       Company
Mar-06                     CompA
May-06       N            CompB

My excel folders get quite large.  I try and find my files by changing my
file format to details and then sort by date to locate my most recent files.  
How can I change the way windows stores my files so that they always open in
detail and the most recent file is sorted to the ...

I try to use averahe function to get result for average salary for each job
position,with data as follows:
Row1    Col A    Col B    Col C
Row2    Empl_ID    Position    Salary

I have a spreadsheet with a customer number on line 1, with additional data
about this customer on lines 2-6 (customer column on these lines is blank).  
I then have a new customer number on line 7, with additional data about this
second customer on lines 8-12 (custom column on ...

y = 1.083333333x4 - 7.3333333x3 + 16.416667x2 - 6.16667x + 4
Above is the polynomial equation of a trend line as shown on my chart,
I have extracted the numbers into separate cells using LINEST, so now
I have in cells A20 to E20 the numbers 1.083333333, -7.333333,

is there a way in excel to get the linear regression function to
specify a function based on a set intercept (say =1), instead of a set
intercept.
I believe this ability should have been included in excel from day 1.

I'm want to use an "IF" formula to compare the values in two cells and return
the following...
IF cell A is equal to cell B I want the formula cell to have a "Y" in it
IF cell A is greater than cell B by more than 2000 I want the formula cell

how do I round numbers in .125 increments

A3 and A4 contain from and to dates.
B1 and B2 contain Year one start & Finish (eg 1/1/05 and 31/12/05)
Subsequent Colums contain subsequent years.
I need help in trying to establish how many days within the dates specified

I'm using Excel 2002 and i would like to calculate the difference between two
dates in days not in workdays.  Unfortunately the help only give you how to
do it in workdays.  Thank you for your help

I'd like to use the rounddown function on range of cells in a
particular column.  Not for any other reason but for viewing.  I don't
need to see 917,248, but rather just 917,200.  However, when summing
the range, I need the sum to calculate the actuals, not the rounddown

You're right Bernie - as soon as it starts to insert the code Excel crashes.
Does anyone have any other suggestions?
"Bernie Deitrick" wrote:

Using Windows xp and Excel Xp2002
When I open up a worksheet in Excel I get a message come up along the bottom
of the screen telling me that it has requested a virus scan. It then proceeds
to do this which adds to the time it takes for a spreadsheet to open up.

I am trying to avoid having to learn Visual Basic to perform the following:
Scenario:
I am building a tool for "sales people" that are not very familiar with Excel.
Through an excel connector program I am able extract data from an external

I have a worksheet 18 columns by 16 rows.  I want to delete only
the numbers in a specific column.  I don't want to lose my formulas.
is this possible?  Thanks