I need to creat a dynamic range that that expands as the range of data
grows but ignors  a table of data that is a few lines below the active
table.  using the countA function to check for empty cells works but
if I have the entire colum as the count range it checks for all non

Can anyone explain why I get the correct answer in the Function argument but
0 (Zero) displayed as the result in the Cell. I have an idea it could be
something in the options

I have a spreadsheet which is essentially just a table of numbers which I
need to add 10% to globally... please would someone let me know how I do this?
Thanking you in advance
Viv

I am working on a history project in which I need to convert acreage given in
decimal form to acres, roods and perches (40 perches = 1 rood; 4 roods = 1
acre). Is is possible to do this in Excel?

I want to track my DVD collection but I only need a list of titles, sorted
alphabetically. Catalogue software wants to store numerous other attributes
for each title and usually offers a complex interface. But all I want is
titles, so I thought that perhaps I can create a simple ...

In a column someone wants a reference to another cell. They want this for a
large nr. of cells, with 15 in between
=D15
=D30

I have a data set where i have daily data for 10 years. I want to calculate
the beta(slope or linest) for each month.
The data is only from trading days, so some months have 20 observations due
to hollidays etc, and some have 25.

In Excel I need to character search a cell and determine if one of 3 text
strings, 01-08, 08-07, 27B can be found anywhere in the cell, if one of them
are found I need UPDATED to show in the results cell, if none of then are
found the results cell will be blank.

1. I have created a blank invoice template is there any way that the
information that is entered on this template can automatically create a
duplicate of itself each time I open the invoice template and add anther
customer?

I'm new to the community here so bare with me if my lingo isn't up to par
just yet. I'm in Excel 2003.
My workbook has 2 sheets; 'Inventory' and 'Source'.
'Inventory' has:

When entering a date into a cell without specifying a year, such as "2-28,"
Excel will put in the default value of "2/28/2008." Does anyone know how to
make the default year something other than the current year?
Thanks.

The newsgroup I used to be able to see and set up using Virgin Net was
"microsoft.public.excel.worksheet"
Now it says it is not a group!
Anyone out there who can prove otherwise?

I have 2 worsheets (sheet 1 & sheet 2).
Column B of sheet 2 (Product Name) needs data from sheet 1.
Data in Sheet 1 is  column A=Vendor Name , column B = Product Name.
I need to sort through sheet 1 to create a list in sheet 2 that specifies

I am trying to imput the following Conditional Formatting relating to costing:
2 columns -
Column A has a costing goal
Column B has the costing actual

I am creating a spreadsheet to make things more simple.  I want to be able to
select a word from a drop down list and once that word appears in the cell I
want the tasks associated with that work to fill in the cells below.  
Example:  One of the words is Chiller.  When that word ...