Here is an example of my spreadsheet:
Review Reason           #claims
BAIR                              10   
BAMB                             15   

I'm not a sophisticated user of Excel but am wondering, if it is possible,
how I can set up a work sheet to figure out how much interest is owed when
someone is paying me late on their mortgage payment.

My spreadsheet (main.xls) has a number of macros.  One of them (macro1)
tries to open another spreadsheet (file.xls).  However, when file.xls opens,
the macro stops, rather than continuing with the rest of its code.  I have
similar code in macro2, but it seems to work as expected.

The values to rank are in K2, N2, Q2, T2, W2, Z2, AC2, AF2, AI2, AL2.
The values are 0, 0, 12, 127, 39, 17, 0, 0, 0, 0
This is the formula I used to get rid of the tie but it is not working -
=RANK(K2,($K$2:$AL$2))+(COUNTIF(H$2:J2,K2)) - I used this in K2 and then

I am having trouble figuring out nested function to pull the correct
information without error. I have created a calendar in excel for various
time periods to show instructors booked for training classes. Across the top
row is a julian dates and down the first column in a name of ...

How can I replace a #N/A result with "0"?

I have a sheet that already has a subtotal function. I used the
Data/Subtotals command and thought myself very clever.
Now I wish to extensively modify the sheet and completely re-do the
subtotals. However the option is now 'greyed out' in the drop down menu and

I am working with a spreadsheet with two tabs of 1,000 rows.  I would like to
hyperlink from one to the other.  I can install a hyperlink in row one, but
when I try to copy and paste for the next 999 rows, the link stays up on row
one instead of following down the the next rows.

I'm using Excel 2003 (Windows XP) and have been unsuccessfully attempting to
count the occurence of more than one condition (I used the formula found in
HELP).  I always end up with VALUE! whether I'm on a PC or my Mac.  So I
designed my own formula that works on both platforms:

I know this function will work on a specific cell:
=LEN(A1)-LEN(SUBSTITUTE(A1,"Z",""))
What about counting all letters Z in range A1:A10?
Seems simple.  I tried a few things; nothing has worked yet...

I am using Microsoft Excel 2007. I have an account number in C:2.
Associated with this account number is a set (in a column) of 3 digit
numbers in W:2, W:3, W:4, W:5. When there are multiple 3 digit numbers
in Column W, there are blank spaces under C:2. When the next account

I downloaded a General Ledger Template from Microsoft. It contains a YTD
sheet, A Monthly Sheet ( Sub Totals by General Ledger Account ) and seperate
sheets for each General Ledger Account.
The formula as written is

I'm using Excel to track price quotes that are entered once a day. I need to
Hi-Lite the  10 day Hi and 20 day Hi in one column, and the 10 day low and 20
day low in another column. The Hi and Low are to seperate columns.

I have a master spreadsheet with hyperlinks to around 2,000 other
spreadsheets. All of the hyperlinks are held in the same column. All of the
other spreadsheets are of a standard format. There are 8 cells on each of
these spreadsheets that contain data that I want to collate in ...

I am trying to print a worksheet but some of the text is not printing.