I am trying to exclude price ranges from <100,000 to >150,000 from my
database, my criteria range is B9:C10.
Price    <100000
Price    >150000

I have an offset function with a nested match function that looks to a
separate spreadsheet.  If I have both spreadsheets open, it works fine.  If
the host ss is not open, I get a #VALUE! error.  The vlookups on the sheet
look to the same host spreadsheet, and they are not ...

I am working on a maths project and I need to plot the derivative of an
exponential curve, however, (as far as I know) there is no function that is
capable of differentiating an exponential function.  I hope somebody can help
me.

I'm creating an excel spreadsheet and need to add business days only.  If
cell a1 is todays date (3/20/06), how do I make cell b1 equal a1+5 business
days, no weekends?

I'm trying to change a column of 6 digit numbers into military time separated
by colons.  Example 180333 to 18:03:33  (hours, minutes, seconds).  I've used
=(A1/100)+(((A1/100)-(A1/100))/0.6) and reformat for time and also
=VALUE(LEFT(A1,LEN(A1)-2)&":"&RIGHT(A1,2))

This is time worksheet:
Time in/time out/Number hours/difference.
First three are fine.  The difference should be the difference  between
column C and 8 hours.

How do i freeze columns over several tabs/datasheets? Contents of these
columns are hyperlinks. Intention is to have less work filling in these
columns in different tabs/datasheets of the same workbook

I have a workbook with several worksheets.  One worksheet is linked to
another and the first column of the target worksheet has an AutoFilter of
Nonblank.  When I choose Nonblank from the drop down, it populates several
columns of information form the target spreadsheet.  New ...

I have an excel workbook where I've queried a table in access. When I
first setup the query, I did it through the get external data query
wizard, browsed, found my access database (called database_010306.mdb)
and selected my table. All was fine.

This is the formula that I am using which works very well.  =IF(E2=0,"
",(VLOOKUP(E2,Worcester,2,FALSE))).  I have a range named WORCESTER for
looking up the answer that I need.
This is fine if the text in cell E2 DOES =Worcester.  BUT, cell E2 will

How do you save a spreadsheet with formulas to appear as values?

here is my text strong:
PO: Trans:DC:MMU - DO NOT BREAKTICKET:ALLOC:RE ORDER OF # 103157131,
101915744. MMU - DO NOT BREAKAP:
I want to return text starting with ALLOC but stop at and not include AP.

I have built a inventory sheet with pivot tables and many equations for loss
and costs and i have used this sheet for many months without a problem.  
However, in the last week when i went to change a formula things got a bit
wierd.  I added another cell to the equation and went ...

I have a sheet with a column of numbers and there are groups that are added
to get a sum of that group.  I want to transfer just the cell with the total
to the next column over.  The "total" cells are the only cells that contain
formulas in the column - I can get it to find them ...

What Function can I use to get data from Sheet2 into Sheet1 based o
input on Sheet1?  IF function won't work because tables will be severa
hundred rows long.  If a function can't be used, is there another way t
do it?