I need a formula that will allow me to rank one column of  numbers based on a
value in another column. e.g. If I have values in column A and countries in
column B. I want to rank the values by country in other words each country
will have a #1 etc. also the number of values by ...

I created a multi-page workbook to determine the sales bonus earned by
my employees.  The problem is that some of them forfeit their bonus if
they don't meet the minimum standards for quality, adherence,
retention, etc.  Also, if someone has not made a sale or attempted

Good Day,
I would like a popup screen to come up automatically when a spreadsheet is
open. This popup will provide directions to the users of the spreadsheet. (I
have a second sheet that provides directions but, I would like to emphasize a

An employee is purchasing vacation per pay.  My spreadsheet works like
this.
Week 1  Withheld             $39.00
Week 2  Withheld             $39.00

I am attempting to find a value using a series of repeditive formulas.  I am
getting an #NUM error, which I know is wrong.  
I am attempting to calculate:
----------------------

i have made excel worksheet, it consist of 15 pages.
i need to total each page
add all subtotals to make
grandtotal on final page

I have 2 companies parts in a spreadsheet.  One set is uppercase and
one is lowercase.  Example:
10x06-398f  4.54
10X6-398F  6.56

I used this formula to seperate numbers in a string and return th
numbers.
Example:
original string "BD456". the outcome is "456"

I am trying to replace the range in an average calculation using the offset
function but its not giving me the result the same as using Excels standard
average function.
Say I want to;

I use YEAR(cell)&WEEKNUM(cell) to organize data in time buckets. This returns
yyyyw numbers for weeks 1 through 9, which when put in a pivot table or
sorted does not sort in a correct date order. Is there a way to force WEEKNUM
toreturn 01 - 09 for weeks 1 thorugh 9 of a given ...

When data is typed into a cell on a worksheet, can that same data be paste
linked to the worksheet tab for tab naming purposes?  Office XP is being used.

How can I make this work? I keep getting the formula too long error.
=if(j4=1,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<3,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<7,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),

When I select a range of numbers to sum the result is zero.  The formula is
shown in the formula window and I am using the auto sum feature so I am not
creating a syntax error.

I am trying to create a formula using the "IF" function to calculate monthly
dues on the first of each month.  What I've done is set up a worksheet for
each month, and I want the monthly dues to be added to each members account
on the first of each month, but not before.  I have ...

if i know the loan amount say 22,000, the APR 10.49%, the loan is for 36
months, but on month 36 i have a balloon amount of 14,500 left to pay. how do
i calculate the monthly payment and the amount of interest i have paid over
the period before the balloon amount is to be paid