Hi, Does anybody know what this error message is: " Excel can not complete this task with available resources. Choose less data or close other...

Hi, I'm built an array that works fine in 2007, but i get the error #NUM! in excel 2003. Can anyone help me determine the problem. Here is my...

I'm trying to create a formula to sum a range of numbers if two conditions are true. Please help. Is there a way to do the following in a cell using a...

I am attempting to pull in data from different tabs in my workbook based on specific month chosen by the user, which is done from a combo box. For example,...

Hi, I have an excel sheet in which I pull data from another sheet using VLOOKUP, as well as the =TODAY() functions. I hope to transfer the values generated...

I have a need to create a list in the fashion of t0 t1 t2 t3 .. .. .. .. tx,

Hi All, I want to use check box from control toolbar. I want this check box to be visible if there is a certain value in another cell. Is this possible...

I have data that is consolidated in columns (up to 15 columns). I want to put a total at the end of the rows, which is not a problem. What I need however...

I have used versions of the basic formula below to count the records remaining after application of the advanced...

We receive a spreadsheet from a vendor twice a month in the same format. It includes 6 tabs in sheet. I need to pick out specific data from each...

I am new on office 2007, I cannot find the way to reset the printing area.

Hello, Report One In Column A I have account numbers from one report, In Column B:H is the data that I'm counting. Each column has headers. Not all cells...

Excel2003 ... Range H10:DC10 contains a Formula which returns ... TEXT, DATEs & SPACEs ("") ... Range Format = Dates 3/14 I want formula in Cell E135 to...

Hello, I need help with match formulas that will return discrepancies between two reports. I would like a third table that will return the account number...

Hello, I have two pivot table on a same sheet with the same drop down list on the top selection (not row or column). Is it possible to select from a...

I'm trying to make a form and want to change cells to different heights to accommodate entry by hand.

Is there any way to total the values that are created by the sub-total function in a grand total? I know the grand total is designed to IGNORE the SUBTOTAL...

I have a pivot table which is using an external data source of an access database. When I create calculated fields in the Pivot table and save in ..xls,...

I have the following on a parent sheet A B C 1 05/01/09 5 8 2 05/02/09 7 7 3 05/03/09 ...

I am working with Excel, trying to remove dashes from Text "000-000-000-000" but still keep zeros. The cell MUST keep all 12 digits including zeros for it...