What is an assumption and how do i set an assumption? I'm taking an excel
course in school and i just wanted some clearafication on assumptions. Thank
you in advance for any help.

Does anyone know a function that will return the first word in a text
string? I know that the Left function can do it, but I want to be able to
copy the function down a column so that no matter what length the first word
is, it will extract it without having to rewrite the ...

I am in the process of creating a macro which will be able to select a
table and create a pivot table based on that data.  The data changes on
a weekly basis. ie the number of rows.  How do i create a table based
on this  The code i have seem to only accept "hard coded" data ranges.

Instead of trying to do this in VBA I have a large excel file with 50'000 +
duplicate postal codes. What I'd like to do is when ever a postal code is in
the file more than once I'd like to delete all of instances of that postal
code.

Is there a way to output two seprate Access reports into one Excel worksheet?
I was thinging about combining two reports into one sheet using the Excel
tabs so the user can go back and forth to see seprate result sets without
looking at two seprate instances of Excel. Currently I ...

An Adobe document is embedded into an excel program (as a package) and
whenever we try to open the pdf we get the error "Cannot start the
source application for this object".  I have upgraded the Adobe Reader
to version 7.0.8.   If you right click on it and select copy then go to

I have two columns of data, first one would be my contract number and
second one would be the date of completion of the contract. How do I go
about using summing up the number of contracts I've completed in a
particular month? For example:

I have a Sumproduct formular that i got from off groups but need it to
work on filtered Data
=SUMPRODUCT((A3:A51<>"")/COUNTIF(A3:A51,A3:A51&""))
Have been trying to us SUBTOTAL(3,OFFSET(INDEX............

What i wanted to do was the followen :
I have an excel spreadsheet which has the following columns
Name Address Town Postcode
What I require is some way that allows the user to choose a town (Towns

When printing a range that will cover a few pages, is it possible to repeat
the header rows or columns on every page (like Word's option for table
layouts)?
Ed

I have an interesting (to me, at least) question with an easy work
around.  Basically, I am working with some REALLY non-advanced users
who would like to search an excel spreadsheet for a text string.  The
problem is that I'd like to have this search be done via a cell rather

I am using Excel 2002.
I have in column D the birthdate of  persons (e.g.:  23-02-1962)
I extract in column E, with the MONTH-function, the month (2  in my example)
However I do not want the number 2, but the text februari.

does anyone know why this formila isn't working?
{=SUM(INDIRECT(ADDRESS(C8;D8;;E8:E108)))}
What I want to do is this: I have a workbook that has around 100 sheets (all
of these sheets are equally arranged), so i want to sum all the figures from

I have two different dated inventory lists with 3,074 of identical line
items. I want to determine the "items" that have "sold units" from two lists
since they reflect ending inventory on separate dates.  I want to create a
new work sheet with those "items" only whose ending ...

is there a bult in tool to add a sort control at the top of columns where I
could sort a range or sheet based on what I select at the top of the column?