I have an array that has about 100 columns and 25 rows. I am trying to sum all the cells within the array that satisfy conditions within the header rows and...

I have data that is expressed in weeks (ie 7 day periods). The start date is not guranteed to be a calendar start week. I want to weight this data so that I...

How do I password protect a spreadsheet created in Excel 2003 for users of Excel 97? I tried saving it as an Excel 2003 file - no good; I tried saving it as...

How do I password protect a spreadsheet created in Excel 2003 for users of Excel 97? I tried saving it as an Excel 2003 file - no good; I tried saving it as...

This may be a service pack issue? Several .xls files stored locally seem to run via my wireless network. Can't scroll down 1 row without reloading. Latest...

Hi, when i copy cells from one to another worksheet, all the name references got lost. Do you have any idea? Thanks, william. --

I have a schedule for 50 people with names in a column A and days of the week in first row: each employee can be assigned to one of four duty stations, be off,...

How can I insert a vertical column break between data to create a new column? I pasted data that has a combination of words and numbers. I want to separate the...

I am using Custom Type Charts in Excel, which uses Pivot Table as the Data Source. The problem that I am facing here is that whenever I Refresh the data...

I'm trying to display zeros as dashes. It works in most cells but in some cells, it keeps displaying (0) even though the formatting is copied to the relevant...

Excel 97 - i need to merge 2 fairly large workbooks, however i cannot use "compare and merge" because my workbooks are not direct copies of each other. There...

Hello, I'm trying to write a formula that depending on the contents of another cell, will either have a number or be blank. Basically, if a set of numbers is...

Here's my problem. I have two spreadsheets. In one spreadsheet (sheet a) i have the part number P123456. in the other sheet (sheet b) i have a rang of part...

I am trying to secure a spreadsheet and/or workbook in Excel 2000 to prevent someone from opening. Only those with the proper password whould be allowed to...

I need to see if I can use my columns to multiply or add or minus from other columns?

I would appreciate any heply in solving what seems a simple problem. I wish to copy down a formula in Cell AA1, that contains a reference to B1 down to AA6,...

Hi, I'm creating a time card that lists time in the 12 hour am-pm fomat. How do I calculate time between in and out (keeping in mind that there will be...

I am trying to create a worksheet that that will subtract Christmas gift from a total at the bottom of the worksheet

I would like to use a specific number of columns of varying widths at the top of a page then, part way down the page, change to a different number of columns...

Sorry if this seems like such a simple question, but I'm stumped, and the Help files are not being terribly helpful--or at least they are not easy to wade...