We have a workbook which has name in column b we have another sheet with same
names but column 1 has id# we would like to have those codes whatever we
tried does not work no idea why
here is our codes we tried

My task is to deteremine an equivalent loan interest rate to a lease payment.
ie: Lease payment term is 60 months, payment is $135.35, funded amount is $5,000
I've been trying to use the RATE function, but need some help entering the data
properly. Every manner I've tried results in ...

Some documents I receive in exel format have sections that I need to respond
to then return to sender. Often the spell check option is not available in
the tools menu. (its Not Darkened). Is there a way to turn the spell check
option on?

Hi guys this is my problem.
I have serial numbers in my entire A column and dates in my entire B column.
On a separate workskeet, I want to create a command that will check if the
serial number is a multiple of 8. If it is, I want it to return the date the

Good morning group.
Formula in Cell F1 =SLOPE(D10:D14,B10:B14)
Formula in Cell F2 =SLOPE(D20:D24,B20:B24)
Formula in Cell F3 =SLOPE(D30:D34,B30:B34)

hi again,
in addition to my previous post, what formula can you suggest for me to be
able to find matching dates and the dates of the week before.
thanks,

I am a service engineer, and i'm looking to use excel to manage my stock better
I have tried a few things and it's all manually input/edited
I would like to know if it's possibale to use VB, to auto manage these levels
IE, 1 box asks for the part number

I am working on a registration form for a meeting.  I currently have a sheet
set up as a registration form with cells for various fees to be paid by the
registrant.  My current plan is to use a seperate sheet for each registrant
(approx 100 - 150) all within the same workbook.

Hi,
 I'm looking for a function, similar to NETWORKDAYS, but that will allow me
to add a number of working days to todays date to generate a deadline,
hopefully I'd like to include Holidays too, just like NETWORKDAYS can, so

I have Excel 2007 and my wife has Excel 2003.   I regularly get Excel files
mailed to me from work that have two Worksheets of two pages each for a
total of four pages.  When I open these files on my wife's machine I can see
both Worksheets and all 4 pages.  When I open it with ...

The computer is set to use the long date format and everything is OK until I
make changes to a chart which causes all dates in all open worksheets to be
displayed in the short date format.  When excel is closed down and restarted
the problem is resolved - but doing this is ...

Hi guys here is the issue.
Under column A, which is titled serial number, I have listed the formula
=IF(ISNUMBER(B28)=TRUE,A27+1,""). What this does is that it detects if there
is a date in column B and then inputs a serial number that is one more than

Hi guys I recently decided to put in my students' attendance into a
worksheet. A sample of one of the student's sheets can be seen at
http://i291.photobucket.com/albums/ll304/dioprem/attendance.jpg (at lot
easier to upload a screenshot than to explain ;))

Tried the C.Pearson site.... Couldn't get that formula to work.
=IF(ROW()-ROW(NoBlanksRange)+1>ROWS(BlanksRange)-
COUNTBLANK(BlanksRange),"",INDIRECT(ADDRESS(SMALL(
(IF(BlanksRange<>"",ROW(BlanksRange),ROW()+ROWS(BlanksRange))),

I have tables of calling rates. I have 5 tables as follows:
_tblAccount - It's an account type such as pre paid or post paid
_tblEmployees
_tblProvider - list of all the providers. I have 7 so far.