The following fomula is contained in cell C16 and returns the correct
values:
=VLOOKUP(B6,'Active Clients'!$B$2:$K$954,10,FALSE)
The following formula is contained in cell L18 and uses the result in

I have lots of groups with subtotals.  I need to multiply the various
subtotals by a factor (factors change depending on the group) that's in its
own column and then get the product (which needs to be an even number
(rounded up).

After I get to about 150 row height the text start moving down and I can't
put any more inside the cell. How can I put more text in the cell without
doing comments? I have Office 2002

This is embarrassing to write, because I am the go-to guy in our office
for almost everything, and I have something I can't solve myself.
At home, I have Excel 2002, but at the office, I have Excel 2003. For
some unknown reason, I am having problems navigating my spreadsheets.

I had series of prices on cell A. I want to increase those prices from
A1:A10000 by 5%

Hello, I wonder if you might be able to guide me in the right
direction.  I am a physician and need a bit of help.  One of the
medications I prescribe is limited to prescribing it to only 100
patients at a time.  This number is based on the script activity.  For

I am constantly adding names & phones #'s, etc. to a data sheet I have so I
need to re-alphabetize each time I add one.  I had a space between each row,
but when I hit the Sort button, it lumps all the spaces together!  Help,
please!

I have a spreadsheet that logs work activities and records team
members' completion of project units.
Column B records team member names.  Column C has project unit status -
'pending', 'beta' or 'completed'.

I have a spreadsheet that records units of work completed by a project
team.
Column B records team member names. Column C records the status of each
work unit – ‘pending’, ‘beta’ or ‘completed’.

I cannot find the tools menu for excell 2007.

I have four worksheets as follow: PC, OZ, IM and KL; each of the worksheet is
containing data.  
In another separate worksheet is performing the analytic function. In this
worksheet, only one type of excel formular is applying: SUMPRODUCT(--(x=x),--

I want to compare three different samples in one graph type XY scatter  line.
Can you help me with that???

I would like to sort my column B data in same sequence as column A.
Anyone please advice
Example.
Before sort::

Col B            Col C                    Col F
Mary                     Team 1                $331.00
George          Team 1                $222.00
Sam             Team 2                $186.00

I have a pivot table that we have sent to out side locations, They are
viewing this table as "read Only" although I haven't protected the worksheet.
Do you guys know of any setting I need to check that could have "secretly"
put this Pivot table as read only?