Please post response as email is bogus to prevent spam.
I am using Excel 2003. I admit I lost my note on this and appreciate
how to do this.
I am filtering data. The original list is say 500 rows. When I filter

I have addresses in an Excel spreadsheet.  Here is how they are formatted:
row 1: (blank)
row 2: name
row 3: address

I want to add all the assets of a company up and use the purchase date to
calculate the depriciation. So far there is no problem. But if I have in one
column the Date, the value and the length of use etc. how do I get in one
column the value for December 2004 and in the next the ...

Help, I'm going nuts.
I have a challenge that is so far beating me.  I have a pivot table that
summarises sales values and margins by month and I had no problem in adding a
calculated field with a monthly budget figure and charted this quite easily.

Can anyone suggest the answer to a simple problem, I want excel to calculate
a nett date on an invoice.
If I put a date in for example 16/12/2005 I want the sheet to return a date
that is 45 days following the end of the month. Effectively the spreadsheet

could anyone tell me how to cover the formula in the column, so that people
unable see what the formula i have put in.
thanks in advance...
Lawrence

I have a list of files in an Excelt document that has alpha, numeric and date
columns.   I would like to total the number of entries (not cells).   Please
advise the formula to do this.   I don't mind if I use an alpha column or a
numeric or date column to obtain this total.  

I am creating an personal expense datasheet. I would like to lock the entire
row if I click/ select the cell. Like I entered my expenses for that day in
cell A1 to A6. And I want that entire row to be locked if I put some value in
A7.

Using Excel 2000, I developed a grid incorporating +, -, words and values.
The abbreviated grid looks like this:
       B         C
3  Average   1

I have  created a data in excel in which one column contains data. I want to
sort the data with respect to the dates entered in the column. It does sort
but the dates are neither in ascending or in descending order. the sorting is
based on the rules of sort in excel. I need the ...

We work in a 24/7 environment.  I calculate production for a seven days
schedule but, we do close for holidays. Networkdays, by default, excludes
weekends when calculating.  I do not see any other date fuction that will
calculate the workdays, include weekends and exclude the ...

I have an application in which I import data into excel and then graph
it on the y axis with the x axis being system time.  I actually graph 3
Y values at once using a list selector.
When I begin importing data, I have a time column which the graph uses

I have identified two cells in a table using vlookup & hlookup.  I want to
sum the cells referred to by the lookups.

I arrive at a value in a particular cell and which I would want it to blink
as in MS Word as a text character. How can I do this without changing the
cell definition from a numeric (present) to text otherwise. Appreciate help
and guidance. Thanks

In an Excel Work sheet I want to examine the contents if the Division column
and if the division is HR change the Font color to red else leave the font
color black. AS an example. IF F2 = "HR", change the text in F@ to red,
change it to black.