copying and pasting a function down a column will increase the cell number by one in each row (example =A1+6, and below: =A2+6 and below =A3+6 etc.) Is it...

I am trying to create a formula that will automatically insert data when item(s) are selected from drop down list. Drop down list is text based, while data...

Is there a way to make the entire workbook protected at once insteading of going sheet by sheet.

I want to SUM two cells in an Excel worksheet but only if there is a value in both cells. For each month of the year I want to show total minutes (B32:43)...

How could I tweak the Data Validation below which in cell J10 where it resides, also include an ability to enter the letters CC? At the moment it requires up...

hi, i have a large spreadsheet and would like to count the number of entries in one column only if a different column meets criteria. for example: Name ...

Greetings. We are working on a capital project and are trying to determine the number of units needed at $0.50/unit to generate a 20% IRR from a series of...

I have a worksheet with data and formula from A1 to M106 with 2008 data. I need to create a new sheet for 2009. I would like to remove the data -but not the...

I have created a workbook where I want any individual employee to select a supervisor and on a seperate worksheet it will show everyone that reports to that...

I am using a Amortization Schedule template from Microsoft Office online. I am trying to change the Per Period from Monthly - Semi-Monthly etc... to days...

I recently transferred to a new PC, bringing with me Excel 97 SR-2 and a clutch of long-serving worksheets. However, I'm having problems entering numbers on...

I am using the Match function to operate similar to a sql IN operator, but I can't find anything that tells me what I am doing is okay. My test results have...

Hi everyone I've got these three sumproduct formulas that returns the right...

hi, i have a large spreadsheet and would like to count the number of entries in one column only if a different column meets criteria. for example: Name ...

Hi, Is it possible to look up not only the contents of a cell, but also the cell color using a vlookup? Thanks,

After I remove a data connection via the "existing connections dialog box, the definitions re-establish themselves the next time I open the workbook. They...

I need a formula on one sheet to reflect a number in another sheet. That number must be repeated 3 times, then the formula needs to go to the next row and...

I have created a spreadsheet in which there is a committed ship date as opposed to the actual ship date. However, I need this calculated difference to be in...

Hello, I have a comma separated list with codes that is set up as G01, G02, G03, H01, Y02, B03, A06. There can be many many codes on each row, but they...

I have the list of names and abriviations on a sheet called info A B C 1 Copper pdx CC 2 Edge ...