Hi Can anyone help on this i have a problem first i have a spread sheet
where i have all the company name and i would like to organized them in
alphabetical order, the second problem is that i have another spread
sheet with the amount each person maked and i would like to add to this
sheet a formula to calculate the amount they will make next review,
meaning i have in one cell the amount and next cell i have the
percentage and on the next cell i woul like to have the new amount they
would make with the increase can anyone here give me a hand on this 2
problems i have you help will be greatly appreciated.
Thanks


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

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