I'm trying to calculate the payoff date for a loan. I'm using the NPER
function, but the result is puzzling.
For a $5,000 loan at 7% interest and a $250/month payment, I'm putting

I have a colum of dates and a colum of websites. What I am trying to do is
lookup
the date and if the date matches. It would then lookup the the webiste and
return the of times it sees the matching date and website to a seperate sheet

I am trying to create a requisition form that will allow users to enter
quantities next to items in a database and return quantities and lookup
values on a requistion form if the item was selected.
Can someone point me in the right direction what type functions would do this?

Here's our problem. We have a table like this:
58    5'630.00
58    997.00
58    489.00

I have column a and column , how to combine two fields to one field.
Column a name client 1, column B name client 2,
I want to combine column 1 & column 2 to one column.
Please help.

Excel 97 SR-1 keeps giving me an error that it cannot save a certain file so
it creates a temporary one that I can open and re-save. Only doing it with
one specific worksheet that is about 20kb in size. I get the error message
about every 10 entries. Strictly columns with numbers ...

Hi to All,
I have formatted cell C5 as follows: ##"F1"
I entered the number 1712 cell C5, which gives the desired result
1712F1

Excel 2003
We have a small group of users who share a spreadsheet.  The spreadsheet is
about 2 MB in size.  The users have complained that the spreadsheet scrolls
very slowly.  As I understand it, the users clean the data out of the

I've a macro that used to remove extra-aneous rubbish from copy and pasted
web pages, but now there are more objects which remain. These are embedded
forms and pictures.
I don't know how I should refer to them to delete them.

I have the following formula that calculates the weight of a
performance based on a weight scale.
H2=GOAL
G3 = PERFORMANCE

Hi thanks for any advice you can offer.
Attempting to build a pivot table using external data, connecting to a
Microsoft SQL Server. I paste the SQL that I use in Enterprise Mgr directly
into MS Query. When I execute the query, the dataset is displayed in MS Query

Range of times in C3:C20.
Want to add only the time greater than 8 hours together.
9.0
8.5

Sheet 1 has the first column named "PINS" containing, say, 1000
different PINS, each PIN having 1...N records. I need to show only a
subset of those 1000 PINS - say 50 PINS.
On sheet 2 I create a column named "SubsetPINS" with 50 records. How

I am looking to modify the way the menus work in excel (specifically,
I am looking for menu changes on certain items).
I have created a custom menu bar, which allows users to access certain
files on our network, with specific search criteria.

is anyone aware of a possible limit to the number of nested groupings
that can be performed on rows? by grouping i mean w/ the expandable
plus/minus signs next to each set of hidden/visible rows.
i am building up a report that contains many parent-child relationship