c3 = "pass"     If a:1 is "Bob Smith" and his name appears in a list of names
B2:b200  .....would appreciate any help.

I have the formula that will calculate the future value of an investment
using variables for the investment amount, interest rate and number of years
(=A1*(1+C1)^B1).  In addition I want to add another variable to the formula
that adds an annual "contribution" to the investment ...

I tried to sort a sheet via VBA and kept getting an error until I
figured it was the protection stopping things. How can I turn off
protection, sort, then turn on protection again?
I looked in help and found ActiveWorkbook.Unprotect ("password") but it

..as i mentioned in my other thread, i am only a beginner to excel :)
My project is centered around the results and statistical performenc
data relating to the soccer results of one team.
Here i am trying to work out an average with a lookup in the sam

I need help creating a sumproduct formula to sum the sales data for
particular sales territory.  The data sheet that the formula wil
reference is set up such that the column headings are in row 28 and th
data begins in row 29 (I won't bore you with why) and continues on fo

Hello I tried performing a validation check so that a value is less tha
or equal to a value in another workbook, but it doesnt let me choose th
cell from the other workbook I guess it has to be in the same workshee
your applying the validation check in right? isnt there a way i ca

I need help creating a sumproduct formula to sum the sales data for a
particular sales territory.  The data sheet that the formula will reference
is set up such that the column headings are in row 28 and the data begins in
row 29 (I won't bore you with why) and continues on for ...

I have a sheet that I want to return a dollar amount for a specific range of %
ages.
EX:
Column E        Column F

first off let me state im a beginner... :)
basically i cant get this dateif thing to work out the yearly age o
someone...it seems fairly simple to me but i cant quite get it working
Well i cant get it working at all, i just keep getting #VALUE! haha...

I have a list of dates I review daily and want to be able to click on an icon
or button beside each date to update it to todays date and not change the
other dates.

I have the following columns:
C                       D                       E
StartDate           EndDate             ContractEndDate
Columns C and D are user-entered fields; Column E is locked.

I have a different worksheet for each day of the week which shows the lates
for invoices per department per store.  I am trying to create a worksheet to
add all of the lates per department together for reporting to the POS.

I have made a budget/expense tracker for personal use, that I would like to
do something with that I cannot figure out how to do.  The expense input
sheets contain two columns that add up where my money went.  I would like to
turn them into drop lists, but I want the available ...

I have a spreasheet that contains 2 columns.  Column A1 thru A1
contains various numbers.  I want to set up an Argument in B1 asking i
A1 is the Unmatched Minimum Number in Column A.  It true I want th
Argument to return the number 1.  If False I want the Argument t

I am doing my Excel hmk, but I having a though time doing the I
function.
I am trying to find the overtime pay. Here is an example.
Name              Rate   Hrs     Regular      Overtime