I need a formula that will help me calculate years of vesting for our 401k
plan.
2 years equals 20% vested
3 years equals 40% vested

I think I was told before that CTL V would allow you to merge the data from 2
worksheets (of the same format) together. Is this true? I don't have anything
to merge at this time but this function has stuck in my mind.
Thanks

If I copy and paste an equation I have in Word to Excel, when I hit enter
instead of giving me a value the whole equation is crammed into the cell. Is
this because it is from Word or is the equation most likely missing something?

I am entering annual sales figures, comparing year to year, and want to get
the percentage change instead of the $ change. How do I do this? Thanks.

Helo friends, who knows a web page with tips regarding array formulas?

Has anybody created a listing of possible alternative options for the
various GET.CELL functions?  Ideally, since it gives the annoying
warning message at startup, I would prefer not to use the outdated
GET.CELL function.

Using Word and Excel 2003 on Windows.
In both Excel and Word recent versions have these little Paste Option square
graphics that appear when you paste text. When you click on the little
square, it pops up a menu of choices with radio buttons, about how you want

I need to create 3 different drop menus, each has to relate the previous data:
Eg., column A has 4 pieces of data,
column B has 16 pieces of data, but only certain data refers back to one of
the data elements in the column A.

I am perplexed!
I think am typically decently savvy when it comes to Excel, and can
usually find an answer to any issue I run across on Microsoft or via
this Usenet group, but this one really has me at loss!

I have 2 worksheets with part numbers and quantities in stock for 2
separate warehouses. I have a 3rd sheet with commonly used parts on.
For the commonly used part Nos, I want to get the quantity in stock for
each Warehouse.

Can anyone link me to a really clear summary of how to create pivot tables?
This is driving me to drink.

I am using 1200+ rows in a worksheet, but there are more than 65,000 rows on
the worksheet and it makes it cumbersome scrolling up and down to make
changes.  How do I get rid of the rest of the rows?  I've tried highlighting
and deleting, but that doesn't do anything.  Thank you,

I have a simple array, just 1 column.
But various numbers are listed multiple times.
using =SMALL(ARRAY,2) or =SMALL(ARRAY,3) or =SMALL(ARRAY,4)
all yield the same number.

I have a number of formulas referring to certain data sheets (named as per
week) like this one..:
=IF(ISNA(VLOOKUP($A2,wk19!$A:$O,2,FALSE)),"",VLOOKUP($A2,wk19!$A:$O,2,FALSE))
The maintenance of the worksheet would be easier if I had those wk19, wk20,

I am using a expense report template from Microsoft Office Excel 2003 Basic
edition,   but would like to change the headings on some of the columns, is
this possible? If so, how