Example: A B C D Person Period Sales Type ...

1. How can I create a Pivot Table from a text file, downloaded from a mainframe database? I have been told this could be done in previous versions of...

HOW DO I CHANGE THE COLOR OF THE EXCEL SPLIT LINE

Is there any way to "tone down" the code that Excel 2002 creates when saving a worksheet as a web page? We converted to Excel 2002 this past year at work and...

XP now has the ability to do a find & replace based on formatting, but i ran across an issue. If I type the word accountant in cell A1 and "accountants are...

Hello, I want to find the maximum value in a column, but I want to ignore the negative and positive part of the value. Basically, the maximum difference from...

How can I search for a string (“Draft Documents�) in sheet1 and then delete all the rows above the row containing the string and then delete the last two...

I received an attachment recently, which, when I opened it, appeared as gobbledegook- I have Windows xp and Offfice 2000 & it seems the attachment was...

I am attempting this for the first time and would appreciate help. Thank you.

I have and excel spreadsheet which I wish to record an error message if one cell as a value of more than zero and the cell below it has a value of zero. I...

Microsoft Office Evolves Community as Part of Office 2010 Launch: As you know, this is a big year for Microsoft as we are launching the latest version of...

can i create a condtional function in a cell that would send data in one row of cells to a cell in another worksheet. ex a1 a2= aaaa a3= bbbb a4=cccc a5=if a1...

Doesn't Excel 2007 have an option to quickly zoom to the full page, the width, or the height? Most current programs provide quick menu options or toolbar...

This is probably very easy, but im having trouble - I want to find a formula that does the following IF H49 + G49 = F49 and F49=I49 then True If it...

I have a master sheet with details of quotations for different clients. Is there anyway to copy the rows of information for each different clients' name...

I have lots of cells with numbers. Can I place a button that will reset all cells to zero? Right now, when I want to start over, I go to each cell and change...

Is there a setting that will highlight a complete row if your cursor is in that row. I know the row number will be highlighted. Thanks

Hello. Column A has dates. The format is 2010-04-29. There are multiple rows with the same date. Column B has numbers Please, provide me the formula IF:...

Save more than 10 pages in order and then keep in folder for use the next day?

I am new to this Excel 2007 and don't know how to put a title where the lettered columns are. I need it to be centered across 4 columns. Thanks for the help