I'm trying to get some values from particular worksheets in other excel files
into my currently open file.  I'm able to build up the filenames and put them
in a cell, say B2.
Now, I'd like to use the filename in cell B2 to get the values from that file.

I am creating a spreadsheet that lists all of our billboard inventory with
one column containing the date the billboard becomes available (example: if
the contract expires 9/30/06 then the "available date" is 10/1/06). I want to
know if there is a way to create a function that ...

I have a large spreadsheet with data in the following format:
Product    Price    Sales
A    $1.00     10
B    $2.00     9

I have a folder with 12 excel files. The first one in the range has a list of
filenames that I need to link to to retrieve specific data. How can I create
a link to external xls files using the filenames in COL F in the first file?

Hi
I am wanting to ranking my bowlers scores.  There will be a maximum of
thirty bowlers. and the highest score for eacg game will get thirty points
and so on down to 1 point.  

I have some validation lists placed on some cells.
But have noticed that due to the refernced cells being sometimes 10 cells
long, they
alway seem to open looking at the last few cells.

I have a very large worksheet that is seperated between item codes and the
categories related to those items. However, the way the worksheet comes
pre-formated:
3160WW      AUD3000

I want to be able to use Excel to find the two lowest of 7 values in a
non-contiguous range of cells.  I know how to use MIN to find the lowest, but
how to find the next lowest?

Excel stops calculating NPV at the end of 29 periods/years.  How do I find
tables that go up to 40 years?

Good evening,
Well it happens every year when school starts; the Kids aren't happy with
the teachers or the parents aren't happy with the kids teacher or what ever
happens in between.  There is a big brouhaha again this year.

I have several columns of numbers in no particular order. I want to
arrange them in ascending order, but eliminate all values that are
repeated. For example, if the original column looks like this:
1 - 4.1

Can anyone help .I should have done this in a database to start with,
however it’s a working spreadsheet that’s growing all the time.
Basically it’s a tally of what I have sold. the problem I have  is  if
the customer has paid or not  I have the text yes  or no  in  a cell .

Using a formula, I need to copy a table to a table omitting rows that meet
certain criteria (like no sales).  This needs to be an 'automated' task since
I have some many.
I have worksheets for each of 50 states that list each county/parish, sales,

I've created a dropdown list showing each of our customers. Each customer has
several locations, so in another dropdown list I would like to show those
locations based on what customer was chosen in the first dropdown list. For
example, Customer 1 is chosen, I would like the ...

I'm trying to find the average for a person with scores in column 4 on
separate sheets. The following function returns #VALUE.. What am I doin
wrong? Because the person may be in a different row on each sheet, I'
thinking I need to use the VLOOKUP function.... Help!!! Also, as a