I have created a spreadsheet that lists the "current" balances of all
our mortgages.  By using seperate worksheets containing each mortgages
amortization schedule, I would like to pull the "current" balance of
each mortgage onto the summary sheet. Is there any way to do this?

Hi - o.k. - I can't help asking because the posted answers to the above
question are so close to something I need.
What I'm looking for is a formula that totals all the unique dates for each
Event Code/Plex combination, example of data below. The challenge is that

I am working on a spreadsheet with alot of lookup and reference functions. I
have gotten to pretty much my last step where i want to pull the lowest
number from a certain range of cells, but in both ranges there are error
values (#N/A).  

I need to let the user chose thier own password.  Of course I will need a
master password for my self to reset anyone that forgets theirs.  Is there a
way to do this?

How do I find the logarithm of a negative number without having error message

I have a file with 65000 rows of data (extracted from email inbox)
I applied a formula to identify which rows had an address
=IF(COUNTIF(A1,"*@*"),"","email")
then a second one to remove the email with our company name

I have a field which is formatted to be a date field (D5) and another field
which tracks if follow up is needed (G5).  I want to use conditional
formatting to highlight G5 if D5 is null, meaning no date has been entered.
Pulling my hair out as I can't quite find the right formula ...

There is the issue I faced, I describe below,
                             A            B         C
D            E            F                        G
                             6/29/07   7/3/07   7/10/07  7/15/07

I face an issue, I have to pull the latest date data in my excel tab.
It looks like below:
                    A           B          C          D
E           F               G

=SUMIF(Reason,(OR("B Scale",B Scale Night)),M20:M33)
I am trying to sum cells in column M20:M33 if the named cells "Reason"
contain the words "B Scale" or "B Scale Night"
What am I doing wrong?

Hello Excel Experts!  I've made a worksheet that includes 1200+ cells that
are linked to another workbook which houses monthly totals.  The worksheet I
created is my "June" worksheet and I plan to use this as a template and copy
to blank worksheets, and do a Find "June" and ...

I have added the analysis toolpack in my excel 2003, but some of the finance
functions (E.g. coupdays, couppcd, etc) do not respond as functions.  In
other words, when I type =coupdays(   excel does not see it as a function.
what could the problem be?

I can't locate XML as an option under Data menu

First thank you for looking at this and sorry for the long post and formula,
if it's not clear please let me know.
I'm trying to figure out how to re-write the below array formula:
=COUNT(1/FREQUENCY(IF(LEFT('[Spares Quotes List V22

The contents of cell A1 are numeric, say 199.  I would like the contents of
cell D5 to be the contents of cell A1 concatenated with some text, like so:
A1: 199
D5: 199 days