I have all data in one sheet, for example (shortly):
Cust.no    inv.vo
1407        exp10
1407        exp11

how do I refer to a column when the number of rows may change dynamically?
e.g column A with 12 rows of data would be a1:A12, with dynamic number of
rows it would be A1:A??
I am using SumProduct to add up those rows which meet certain conditions.

I have a bunch of worksheets showing rental income data across four
different cities. Within each city there are about eight (8) different
real estate types (ie 1 bedroom, 2 bedroom etc.).
How can I calculate an average (in a new worksheet) of a specific real

I am trying to take one figure from a spreadsheet workbook and carry this
accross to another worksheet no calculations are required i just need to
carry the data accross please help!

Is it possible to save anExcel Doc (currently 2.3mb and rising) onto aFloppy
Disk? The OS I am using is Windows ME. Any help/assistance would be
appreciated.

I have a spreadsheet that I need to colour code specific cells if they meet a
certain condition.  I know I can use conditional formatting but only 3
conditions can be met that way.  I need to put in conditional formatting to
accept 6 different colours.  How can I do this????  

I am tring to use the conditional formating to change the colour of a cell
depending on the value.
For exemple I want the value in A1 to turn green if the value is greater
than the value in B1 by 10 or more.  And I wan the value to turn red if the

I'm wondering is it possible to (conditional) format say a row of
consecutive cells based on the value of seperate single cell? and i
so, how would i do it?
ie if the cell was "No" then the row would have background colour Red

The lookup functions in Excel only look for values equal to th
specified value or the largest value below the specified value. I wan
my function to find the value as close as possible to the specifie
value.

How can I check to see if a value in a column is contained within a list or
range?
I want to add up only those rows which match the following criteria
If column L = "LDC"

The worksheet lists card numbers in one column and text codes and package
labels in other columns.  Some card numbers repeat due to different
codes/labels but remain in ascending order.  The text columns are in random
order and some also repeat for other card numbers, but there ...

I am using data validation on a cell and using a list of option ( part
names etc...) and wish to know if there is an option that a user can
start to type in a name of the part and the cell would automatically go
to the first possible option..i.e the use types in the letter p and the

The worksheet lists card numbers in one column and text codes and package
labels in other columns.  Some card numbers repeat due to different
codes/labels but remain in ascending order.  The text columns are in random
order and some also repeat for other card numbers, but there ...

How do I change columns from numbers to show letters?

How do I get a combo box to return values not numbers. My combo box
displays January - February, but my linked cell only displays 1-12. How
do i get what is actually in the combo box to appear in the linked
cell.