Each account number should be scheduled a various number of times per week.  
Column A = Account Number;
Column B = Times/wk they SHOULD be scheduled
Each row represents a scheduled service, i.e. if they are ACTUALLY scheduled

I'm using INDEX(...,MATCH(..,...,...,FALSE)) to match two columns with names.
The names in the columns are not identical but I still would like to match
them, even if there is an extra space, coma, or one is capitalized and the
other isn't.

I have copied a full 156 sheet workbook completely as another sheet to add
about 32 more sheets to the group. Everything worked fine however all the
formulated cells do not calculate in the new workbook sheets unless I some
how activate them by clicking in the formulated cell and ...

Currently I have a cell with this formula:
=A2 & !D6
Cell A2 contains the name of another tab in the same book and I wish to
display the value from cell D6 of that sheet.   Clearly the above syntax is

I need a formula that adds only the rows in a a column if the column next to
it (dates) are at least a day behind today
           D       E         F
1         2/1    600

I need to create a form (using Excel) - and in that form I need a date field
to populate.  The problem is I need that to happen the first time only.  So,
"ctrl ;"
puts a date in a field, and if there is a way to create an embedded process

If I have values in cells A1:B2 for example
1,2
3,4
In A4, I'd like to be able to type the cell, and have B4 populate with the

I have a workbook with 31 sheets for each day of the month, I also
have 5 sheets for weekly data.
How do I for every month put a date on a menu sheet so that the start
of the month (day) date is put into the right sheet and have the

in a worksheet is there way to automatically elimate all the blank rows in a
selected range

The standard functions in excel allow to calculate duration in hours
and minutes, using the format hh:mm for the result. However; hh:mm is
normally used only for clocktime: any duration of more than 23:59 will
start again from 00:00, whilst the result could be any figure (24:00;

I have a cell with the following "If" statements. Im aware that you can only
have 7 "IF" statements in a cell but how would i change what i have to a
working formula? I believe "Lookup" is an option but never used it before?
IF(AND('Order Data'!C25="G",'Order Data'!C7=5),'Order ...

In quattro, the formula @max(@abs(B5..B200)) would return the maximum
of the absolute values in cells B5 to B200.  I am having troubles
finding a function in excel that will do this
basically returning the max of an arrays absolute values.  I know I

Is there a way to use an insert page break command in an if then formular

I am getting all of my "ifs", "ands" & "Vlookups" real confused on this one.  
Any help is appreciated.
Here is what I would like to be able to do in J20 in sentence format:
[1] Find the value of H20 in A2:A11 (it will always be one of these values)

I have what on the face of it appears that it should be quite straight
forward but I'm struggling! I've tried using the SUMIF & OFFSET functions but
can't achieve what I'm looking for
I have a list of data in cells A1:D6 within 1 spreadsheet