I have a question? When you are making a cell with a formula the references are set. But when you copy the cell each cell reference changes relative to the...

Hi, I have 30,000+ rows of order lines (extract from database). I have a report setup that takes four criteria (retailer chain, order type, product group,...

I got minium order quantity and firm order quantity in a pivottable, and add a calculated formula for order quantity which should be a least multiple of...

I have two spreadsheets with columns of variables. I have a unique identifier variable consistent in the two spreadsheets, but some columns in the second...

Thanks in advance for any help. Here is my challenge. I want to track stats for players on rows. Have a different row for each of the last three seasons...

Hi Group, I am in "Microsoft Excel Data Analysis and Business Modeling." Chapter 42, pg 342-343 and put the R squared value on a chart, which equals .9828....

Ok guys, here's one to work those muscles. So far I have the following...

Is there a way to count cells that have been highlighted similiar to using the COUNTIF but instead of a variable checking for the formatting of a cell?

hi - I want to report a fixed value of '1' if the term 'defect raised' appears in a range of cells, regardless of frequency. the current formula I have is...

I currently use Office 2003. Is there a format i can set up for cells where i can type in just 4 characters for a time, say 0845 for 8:45 AM without having...

I have a filter on my worksheet but it becomes inactive if I protect the worksheet.

I need a formula to copy rows of cells from one sheet to another based on a specific cell name value (North, Central, or South). I will have a master sheet...

In Excel 2002 I want to insert a command in certain (not all) cells that once data is entered therein and "enter" or a hot key is pressed advances the cell...

Hello, I want to find the average value of one cell in every sheet in a workbook, and display it on another sheet (preferably in the same cell). If this is...

I have a data validation which uses a (dynamic) drop-down list of up to 1500 names. Those names will not be entered alphabetically, and the worksheet is...

Hello - I've searched, but cannot find what I'm looking for... I need to do this: In the cell A3 the formula should say If A1 = "red" and if A2 = "blue"...

I believe that it is possible to reset the last cell in Excel. That is restrict the number of columns and rows to those required for the specific data. How...

I can't figure out the formula to get this calculator to work http://www.smartmoney.com/retirement/now/index.cfm?story=moneylast I've tried combining the...

Hi, I have few rows which are alphanumeric cells, I need to extract only the numbers from the cell. For Eg: One cell contains...

Hi All, E.g. in cell A1, sheet1, I have =sheet2!D12 to reference whatever is in sheet 2, cell D12. I want a formula that looks into A1 to see what is...