I need help using goal seek and solver.  Does anyone know of some basic
information/tutorials available?

I have two long worksheets that serve as address lists.
My problem is I believe there is duplication on the lists.
Here's an example of the data
Full Name  First    Last     Salutation    Home Address BusAddress   Sponsor

trying to use sumproduct fuction with dynamic ranges,
Example "column a" has problem as heading and "column j" has status as the
heading,
I put in a formula of somthing like

I have 2 compare model in one worksheet 2 model in another and if it matches
then bring the corresponding value, would any formula work?If yes then please
share with example...
Example:

To the well I return...!
Here's the deal: an excel worksheet (Trial balance) is populated (approx.
3,000 rows) from a download and has 4 columns (first 3 are text and 4th is
numeric).  The 1st column has values of 00, 01, 02, 03, etc. through 20.  I

Sorry to bother you guys again.
But I'm stuck, and you where all such a great help last time.
I have an invoice sheet and a Product Summary sheet.
I want to take the rows from my Invoice sheet and add them to my

I have a column of various text answers and I want to count the number of
times they appear, but I also have criteria which hides rows of information
and I want the count when these lines are hiden.

Where can I find a COMPLETE list of the functions provided in Excel? I'd
prefer not to have to look in several different places each of which gives
only a partial list.

I have a worksheet that I have three different drop down lists.  I want the
users to select one value from each list and after they do so, I want a
response to display, depending on the selections they have chosen.  How can I
go about doing this, assuming that it can be done?

Hi.  Can anyone lend some insight into any available methods within Excel
that would remove any HTML tags from a cell, while leaving the remaining
text?

(I hope I explain this ok without confusing everyone)
I have entered the formula below to do a sort of vlookup and sum calculation
from another worksheet.  I've used 'iserror' to show blank where no values
appear, i.e. for rows where the vlookup criteria does not appear, I want ...

IE: Time starts at 7:00PM on one day and ends at 5:00AM the next morning.  
When I do it the conventional way it calculate 14 hours when in fact its 10
hours.  Any help would be greatly appreciated.

I have a problem, I have a workbook with 30 sheets, I have a carryover
sheet which has a persons name in the cell. I was hoping that if you
changed that persons name on the carryover sheet it would update all
30 sheets where the name is placed. It wont update, any ideas what

I am working on a project for my job and need a page numbering formula that
says:
Cell x is 3
unless Cellxx contains data, then cell x should be 4

I need to use a vlookup and sum function (I think) in an Excel 2000 workbook
with two worksheets.  The Update worksheet shows client ref in column A, then
along each row, shows various monetary values of business done by each
client.  The Summary worksheet also shows the client ...