If you have a column of negative and positive numbers, how do you transfer these numbers all to be positive in the next column? FC

I saw a post with this question, but it had a sumproduct function. I need to count the number of instances with a certain person, and from a certain dept. I...

Message above. I have tran.Id and item#. How do I trace or find out where the package is. I have the page receipt. Thank you

I know there is probably a simple answer to this, but I have a spreadsheet that someone else created. In that sheet there are various formulas and 1 column...

I have a drop down in cell F37 that has the options AL88 and AL667. In cell B93 I put an =IF(F37=AL88,2,0), but when cell F37 shows AL88, cell B93 is...

We upgraded to Office 2007 a few months ago. One user in my office suddenly can not copy and paste to different workbooks in Excel. He can c/p within the...

I have observed wind direction in 16 point compass names and forecasted wind direction points in the same text format. Can I use excel to create a 2 x 2...

I must admit, it has been over three years since I worked with Excel, but I thought it would be more like riding a bike going back into it. Situation: I have...

Hi, I'm a beginner to Excel. I have a simple .XLS file of 25 rows one column of which sometimes has several lines of word-wrapped text. Everything looks...

I have a line chart with multi-level category labels on the x-axis. I want to have gridlines for every BIG category division but not for every small...

I'm at my wits end here!! (insert me eating chocolate and drinking coffee) I'm doing a simple find/replace. If I hit the 'replace' button so that it...

A coworker asked my why her columns heading in Excel are numbers instead of letters. Does anybody know what happen or how to change them back to letters?

Is there a function which provides the sum of the values in column B that correspond to a specified value in column A. eg A B 1 2 1 3 2 0 3 ...

when iam in week mon-fri , teh date in a cell say J1 should show that week's friday date . for eg., when im in anyday between 18 and 22, that paticular cell...

I have a formula for finding the flow over a horizontal weir. ( gpm = 3 * weir L ins. * overflow ins. 1.5th) I want to set up an Excel formula to give the...

I have an EXCEL 2003 file containing about 7000 addresses like this: FIRST LAST NUMBER STREET Mary Smith 123 Main Tom Jones 789 ...

I have groups of rows with first cell identifying the group and the rest have values like: part1 10 8 11 part1 9 4 15 part2 13 14 6 part2 3 ...

Hi. Can i get anywhere the equivalent German XL menu commands please? Thanks John

Hi all, I have a HP laptop with MS vista ultimate and MS Office 2007. my problem is when I'm trying to open an Excel file it hangs and not respondign and show...