I have the following table in a1:e6 Active 24,999 74,999 99,999 ...

I have always been able to view my highlighted cells while working in my document but recently, the only way to view highlighted cells is by previewing...

I have a spreadsheet with what excel refers to as a negative date, example: 20030112. What I want to do is format the date as 2003/01/12 or 01/12/2003, but I...

I have a pivot table with two row fields. Excel does a nice job of formatting the table automatically, but it includes a total line when the first field...

Hello. I am wondering if someone can help to pull the price (3rd column) on worksheet B into worksheet A, based on the priceclass. I know that on the...

Hello. I need a worksheet function that will tell me the most frequent occurrence of a single character string in a range of cells, the second most, and the...

I'm coaching my softball team this year and have decided to determine the lineup based purely on performance and individual player preference. Each player...

I need some assistance in doing a SUM function. The cells I am trying to SUM may have an #VALUE error in them. How do I get the SUM to not include those...

I have been trying to print off the sheet that I am using to check the formulas myself. I know there is a way to do this but can't seem to remember...

When I ;preview my worksheet, the line from the cell to the comment looks fine, but when I print it, it is weak.. how do I change that so it is darker?

Have a look at Countif as you can put a criteria in for the check marks -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any...

thanks! "john" wrote: Have a look at Countif as you can put a criteria in for the check marks -- John MOS Master Instructor Office 2000, 2002 &...

i am using excel 2003 and am trying to use the SUMIF statement with the below calculation: =SUMIF('U:\Operations...

toolsoptionsview check box for formulas or shortcut Ctrl + ` (the key to the left of the 1 key) -- John MOS Master Instructor Office 2000, 2002 &...

Have a spreadsheet containing vendor names in column A, and the column headings of C,D,E,F and G contain criteria names for evaluating them in a number of...

I have a combo box that contains a drop down box of over 11,000 part numbers; I would like to be able to input my part number without going through the whole...

Try using SUMPRODUCT, although you'll have to use a defined range rather than the whole column, e.g. =SUMPRODUCT(--('U:\Operations...

Hello from Steved The below formula works perfectly except if no data it leaves a small square box which siguests to me it is a character, please how do I...

I have a calander that was made and one cell has two dates in it. How can I put a line between the two numbers and color one half of the cell. I know it...

I've used SUMIF for simple calculations such as: SUMIF($F$32:$F$39,"Contracted",$H$32:$H$39) on a single sheet. How would I work that using INDIRECT to...