1. To put them in alphabetical order select the entire range of data
that you
have, go to Data-Sort select the column that your company names
are
in, check ascending and hit OK. Note that if you have a column
heading
you can check header row and then choose your column by the header

row.

2. For the future salary do this:

Assume B2 is current salary, C2 is percent increase put the
following into
D2:

=B2*(1+C2)

copy this formula down for as far as you need to.


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=513300