|
|
excel start directory by
katto01
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...
|
June 9th, 2009 12:43 PM
by Joel
|
1 |
117 |
|
|
sum for match criteria by
Neall
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...
|
June 9th, 2009 12:13 PM
by Neall
|
6 |
192 |
|
|
|
|
16 |
236 |
|
|
|
|
2 |
145 |
|
|
Filter - not = by
LiAD
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...
|
June 9th, 2009 07:37 AM
by LiAD
|
3 |
159 |
|
|
vlookup error by
Matin D HJE
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...
|
|
3 |
149 |
|
|
|
|
3 |
120 |
|
|
Trim with Country code leading by
Cassius
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...
|
|
3 |
183 |
|
|
Sum until hit blank by
Tami
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...
|
|
8 |
225 |
|
|
help with criteria and sum by
akantrow2
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...
|
|
4 |
103 |
|
|
|
June 9th, 2009 06:01 AM
by Kassie
|
9 |
166 |
|
|
Convert Square Feet to Gallons by
Texins Karate
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...
|
June 9th, 2009 02:49 AM
by John
|
4 |
179 |
|
|
|
June 9th, 2009 02:48 AM
by drober
|
2 |
114 |
|
|
Count Function by
Té
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...
|
|
1 |
131 |
|
|
|
|
4 |
158 |
|
|
|
|
1 |
156 |
|
|
Trim cells by
Cassius
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...
|
|
1 |
145 |
|
|
Unique count is criteria is met by
Neall
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...
|
|
2 |
156 |
|
|
Time factor by
Debbie
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
|
|
7 |
120 |
|
|
Combining IF with VLOOKUP by
Ricki Miles
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...
|
|
2 |
161 |