I have been given somebody's library to catalogue and provide a search
engine for. At the moment it is in text format in column A.
The following is an example.
G:\Books\N O P\Nigel R Clough\Nigel R Clough - How To Make and Use

Could anyone suggest a way to rationalise this formula:
=SUMPRODUCT(('Tests 1'!$Z$3:$Z$970="Derbyshire")*('Tests
1'!$AG$3:$AG$970="TERMINATED")*('Tests 1'!$AE$3:$AE$970>=$C$3)*('Tests
1'!$AE$3:$AE$970<=$H$3))+SUMPRODUCT(('Tests

Using Excel 2002
Can't believe this! I have a spreadsheet that totals my services;
calculates the taxes and than I send it of as an invoice. I've taken up
a job that involves traveling and the company pays fuel expenses at 14%

hi..
Datas are:
    A    B    C    D    E
1    AA08    AA07    AA09    AA30   

I have had an add-in module for several years. I want to split it into
two modules. The current add-in module (Add-In 1.xlam) is in
C:\Documents and Settings\Administrator\Application
Data\Microsoft\AddIns

I have office 2000:
I want cells to show up as fractions, but I want them all in 1/8th
increments.
I don't however want 2/8, 4/8 or 6/8, but 1/4. 1/2 and 3/4.

In Excel 2002 (10.2614.2625):
1. Launch Excel. Get or load a new workbook.
2. Do a search by values (Edit / Find / Options / Look in / change
Formulas to Values, execute).

I am working with a Countifs formula, and it is not returning the correct
information when I am using the specific data I want, but if I simplify it,
it will return what I want.  i.e.
=countifs(A3:A500,"1/?",B3:B500,"DAYTONA",C3:C500,"SMITH, JOHN")

I have a table of times that vary from seconds to years. I've been
using a custom format to get times less than a day to display as
h:mm:ss and times greater than a day to display as dd.d. Here's the
custom format string:

With Word, I can to Options/Advanced/Save and choose to Always create backup
copy. Then, every time I resave a Word 2007 doc, I get the backup with a
.wbk file extension.
I just can't figure out how to do the same with Excel.