Hello, I use excel 2003. I defined "Z:\ TEMPLATES\EXCEL\START" as my excel start directory. "Z" drive is a network drive. I am trying to use the same start...

I am trying to get a sum of part cost for each year I have a table with dates that are between 39814 (2007) and 40908 (2011) this is Column A, in column D...

I have 3 cells, containing either yes or no. I want to calculation where sum of cells is no, no, yes (answer is No), or yes, yes yes (answer is yes)...

I need to get excel to add a number of hours (ie 103.65) to a time entered (ie 12:31 pm)

Hi, I have a database of products, times usual type data, text etc. I would like to apply a filter to see certain items in a particular list. For...

I am using Excel 2003. Using the following data table (part ncluded) I am using Vlookup to look up a corrction value for 'A' in cell b3 based on the table...

How do I combine 2 worksheets in the same workbook, so that I can create a pivot chart? The only problem I have is that if I try to manually combine the two...

I have some cells with two charcters leading and those are generally the country code. How can I parse those out the country code and space to just see the...

hi. I need a formula that automatically sums down to the first blank cell. In the data below i need a formula for the Total lines below...sometimes there are...

Hi - I would like to know how to make certain cells one color, other cells another color, then sum those cells based on their color. Could someone assist...

I work for a retail company and am trying to get the formula to show which location has the highest rate. For instance - Brandon has 25 sales, Tampa has 30,...

We are planning to build a new 400 sq ft pool and I want to determine how many gallons of water it will take to fill the pool. I cannot figure out the...

Vendor Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Jun 8 Jun 15 Jun 22 Jun 29 Jul 6 Jul...

Is there a function that will count how many times I have entered a word in a range of cells? I tried using the count function, but that only works for...

I'm creating an excel sheet with drop-down menus using validations. I'd like to create a second row that looks up a list of equipment types from the first...

I have a contact sheet for a youth group that includes their current grade (e.g. 6th). Is there a way for Excel to manually increase this grade number every...

I have thousands of cells with text that I want to eliminate certain text or atleast parse out. A sample of the data is below. CPS-PL-WARSAW-PIPETEST...

I have a list of customers over the past 4 years, they are differentiated by customer numbers. What I would like to do is in one cell per year give me a...

I'm sure I'm overlooking something simple... Please help: I'm adding time differences of: 0.02 (Minutes) 0.09 0.02 0.99 0.20

I am using Excel 2003. I would like to be able to lookup a value in a list. What the lookup returns will be determined by whether or not there is an "X" in...