First I like to thank Max for all the help of my previous post.  Second, I
like to thank the others for the help on my other posts I made a few months
ago.
I have a simular excel file that just has an extra addition, but with my

Have a list of dates from present through the end of year, usually only
Wednesday through Saturday in Book 1, and named the range of dates.  Then I
opened a new we will call Book 2 and tried using Data Validation but all I
see in my dropdown box is the Excel numbers associated ...

I have a sliding scale price list (in a separate table) ie
Qty              1-99      100-399    400-1999   >2000
Price            28.00    24.00        22.00         21.00
SKU1

I need a formula to use with conditional formatting that does all the
following:
If G4=Y (TEXT)
If G13=R (TEXT)

I need to get the total hours  by multiplying number of staff by number of
hours./mins.   Inputting 30 minutes gives me incorrect restlts ie
three staff multiplied by 30 minutes results in 90 minutes
this should be 1hr and 30 mins

Hello, I'm creating a spreadsheet, and I'd like to have some of the cells
default to negative values no matter what value is input (positive or
negative).

I have an excel sheet that calculates a customer's usage forecast.  I use
formulas like MROUND and IF statements.  For some reason I'm getting a #Name?
error now in the MROUND formula.  My first formula is =MROUND(F5,D3).  
My Tools, AddIns has both Analysis Paks checked off and ...

Hi Group!
  My first post, to ask a very hard question (or it is for me!!!)
about getting a total of specific objects ("VALVES", etc.) between two
calendar dates. I am putting the totals on Sheet 2 of the workbook,

I'm not sure if this is possible or not, but it's worth a try. I'm running
Excel 2003.
I'm trying to do all of this in one cell, rather than adding an additional
column. I have two columns that I want to compare. I want to count the

My data in B2:B1000 contains text and numbers. In D2:D1000 I need to return
the findings of a search in B2. Eksample: The text in B2 is "Add FCM#6". I
want to search B2 for text containing FCM, FCN, FCO, FCP, ect. If I find one
of these combinations I want the found text to be ...

Once I create a formula and have tested it successfully is there a shortcut
to change some of the cell references to be absolute references or do I have
to arrow over and enter a $?

Ladies and Gentlemen this is my problem;
I have a spreadsheet that has 3 tabs for details of sales including profits.
I want to create a commission sheet for each salesperson and transfer only
the data that relates to that salesperson.

OK I am a bit confused.  I have a bunch of data,  Column D has various
digits that signify different things fore example 0 = Apple  10 =
Orange.  I am doing a simple count [=COUNT(D2:D567,0)] to get a count
of 0's  instead I get the count of all data which sums up to be 567.

I need a macro that allows the user to select the file. I have figured out to
write a macro for specific path however, as this workbook will go to many
differnt users that will have differnt names and paths for the file. Any help
would be awsome. Thank in advance.

Thursday, September 06, 2007
Here is my problem:
Have an excel spreadsheet trying to track "customer complaints" and
how they are treated by my CSR, dispatch, accounting & Op. Mgr. Each