my data table is as follows: 16-Jun-09 29-May-09 15-May-09 28-Apr-09 7-Apr-09 Slow Slow Slow Dead Dead 1000 ...

I have info in a document that is more than one page long. Is it possible to make two columns on one page. I would like to keep all of the information on...

I am looking for a way to formulate the data in C19-24 as well as D19-24 using the information in A,B,C and D 1-4. Please note it is counting the data...

Hello! Im curious to find out if it's possible to insert the page numbers & sheet names of other sheets into a table which summarizes all the sheets. for...

In excel 2003 I used to get a pop-up box asking me if I wanted to update links to other excel files or not. I just switched to 2007 and I do get the...

I have a number of CSV files of data that I want to Union together into a single table in MS Excel. All the CSV files have the same names and number of...

is it possible to write something to automatically save info to the next empty cell on another sheet

I have the need to calculate 4 weekly periods with the periods starting on a Thursday (historical reasoning) as follows: Period 1 Start-29th May End-25th...

can anyone help me figure out this problem? I have an drop down option list, and i would like to create an if statement that will hide select rows depending...

Hello, I am looking to Copy a cell then paste n rows lower. I would like this number n to be a value in a cell. i.e. If cell A1 = 2, then copy B1 two rows...

How can I equate the size of row and column with inches? If I want a column to be 1" wide and the row 1/2" high, how do I do it? I have a work-around, but it...

I'm creating a large flowchart in Excel. I need to insert "photos or snapshots" of additional excel docs. as mini-reference pictures. How can I "copy" a...

Hi, There's no formula that I know of that will cater for what you are looking for. What you can use is a VBA function to calculate the month difference. Try...

I have a 3 sheet workbook with data in each. One of the sheets won't scroll up and down with the mouse wheel, the other two will. Why?

Dear Sir, For Example is : 2785.000000000000002 I want in MS Word when i use mail merge 2785.00 or 2785.20

The formula 'box' is quite clear. There is a range of data, ONE criteria box and a range to be summed. All quite clear but there doesn't seem to be the...

Hi there, Does anyone know if it is possible to change the default subtotal in a pivot table using Excel 2007? For example it is it showing a subtotal for a...

Hi, I have two array tables and want to do a vlookup on both simultaneously. both have colunms 1 to 4, i want to recal the value in colunm 4.thanx

I am setting up a expense report using drop down lists for TYPE;ie airfare, taxi, mileage. I also have a column AMOUNT that I have designated to be in...

I am trying to Autofill a cell with the information from another cell. For example if a cell in column A contains the word TESTER in the sentence. I want to...