WHEN I COPY DATA FROM A SPECIFIC CELL IN WORKBOOK "A" TO A SPECIFIC CELL IN
WORKBOOK "B" THE COMMENTS SRE NOT TRANSFERED. HOW DO I FIX THIS? HELP
PLEASE!!!!!!!!!!!

I have a column of random numbers that are conditionally formatted for the
font to be blue if the number is => 0 and red if <0.  How do I find the
longest run of numbers that are => than 0 and the longest run that are < 0
within the column.

i am not able to change the cell six, the plus sign does not change when i
move the cursor to the corner of the cell, there is some kind of lock on the
cells, i tried , sheet protection, work book protection and stuf, but to no
avail

Hello.  In sheet1, cells A1:A3, I have 3 dates.  In sheet 2, across
row 2 I have lots of dates.  In column AA, I would like to write a sum
formula that will sum the 3 cells that match the dates in Sheet!
A1:A3.  And then be able to copy that formula down on Sheet2.

I am putting together a freight matrix to calculate the loadfactor on
truckloads.  I have run into a problem with some of the product because it
cubes out the truck verses weighing out the truck.  On the product that
weighs out, I am able to use the IF function to make sure I am ...

I've seen lots of posts about how to split up name data when there are a
known number of names within the cell or when the surname is the first item
in the cell.  
Can someone please tell me how to split out the surname when I have data

Hi...again...Im sure this is really simple....
I've put in a formula:
=IF(I9="y","mm Used This Job"),IF(K9="y","cm Used This Job")
It works fine until the second IF, then I keep getting a #VALUE! regardless

Hello Everyone,
I hope you can help me with this. I have a report from SAP in Text format.
One column needs to be sort buy 2 or 3 letters with in the discription the
cell.

Good day,
I need to know how I can enter a percentage from a total into a line by
using the & & & & & & feature.The problem i've got is that it gives me
93.5676458748534563

Is there a way that I can sort by a column in a Pivot Table that is
not the first column? The sort option works only for the first option
and does not work when I try to sort by any other column.
Thanks!

How can I randomly sort an Excel spreadsheet containing names?

I have a two part question.
Part 1 - I need to get the count based on the criteria in two columns,
In the below
example I am looking for a formula that will give me the count for

How can I add PH Stat to my Spreadsheet?

If I had a list of employees that have certain metrics and each of these
metrics are ranked, how could I identify each employee's biggest are of
opportunity?
ex.

I have an incentive matrix that pays a reward based on a range of
satisfaction scores.  The target satisfaction score is also dependent on the
number of employees of the company being measured.  As an example,
Payment    X(<11)    Y(>11<19)      Z(>19)