|
|
|
September 23rd, 2008 03:28 PM
by Spiky
|
1 |
199 |
|
|
|
September 23rd, 2008 03:24 PM
by Spiky
|
1 |
196 |
|
|
Help, I need a formula for work. by
Che028[_2_]
Help, I need a formula for work.
Here is a generic version of my problem
Leauge Team Attendance exceed 20,000?
American Yankees Yes
American Red Sox No...
|
September 23rd, 2008 03:16 PM
by Spiky
|
7 |
317 |
|
|
Using VLookup and Conditional Formatting by
Andy B.
I am currently working on a project with the company I am working for and we
are having some difficulty with an excel formula. We're basically working out
of...
|
September 23rd, 2008 03:16 PM
by Stefi
|
4 |
226 |
|
|
Classify grups by
Tiiii
hi,
How do I create a column that classify grups, like if i have one column with
numbers from 0 to 2000 and I want another column that gives me a number like...
|
|
2 |
146 |
|
|
|
September 23rd, 2008 02:06 PM
by JP[_5_]
|
7 |
333 |
|
|
|
September 23rd, 2008 01:33 PM
by John_J
|
9 |
465 |
|
|
average based on criteria by
ramudt
i am having the values as follows
PRODUCT MFGDATE
====== =======
AAAA 01-SEP-08
BBBB 02-SEP-08
CCCC ...
|
September 23rd, 2008 12:37 PM
by Mike H
|
7 |
199 |
|
|
|
September 23rd, 2008 12:29 PM
by ramudt
|
2 |
127 |
|
|
Checking for Duplicates within a Workbook by
RAYCV
Hi, I am using the following array formula to check for duplicates within a
worksheet.
{=IF(MAX(COUNTIF('Daniel S'!A4:A1000,A4:A1000))1,"Duplicate","No...
|
September 23rd, 2008 12:10 PM
by Lori
|
7 |
184 |
|
|
Average column by
[email protected]
I have a column of cells which contain some cells with values (ie:
4,6,3,5,7 etc.) and some blanks (cells which possibly will have values
if circumstances are...
|
|
4 |
194 |
|
|
|
|
0 |
558 |
|
|
Equation required by
Junaid[_2_]
I am trying to generate an equation to generate the total value in one column
if there are two categories are same in two columns. e.g.
A B ...
|
September 23rd, 2008 08:25 AM
by Mike H
|
2 |
160 |
|
|
|
September 23rd, 2008 03:23 AM
by T. Valko
|
5 |
153 |
|
|
autofilter average without zero by
jane
I am using the Subtotal with autofilter to average the visible cells but I
need to exclude zero values.
please help.
thank you in advance, jane
|
September 23rd, 2008 03:18 AM
by T. Valko
|
2 |
263 |
|
|
VLOOKUP from multiple table_arrays? by
Seebs
I have what probably should be in one many-rowed table broken into three
separate tables side by side just so I can see them more easily....
|
September 23rd, 2008 03:09 AM
by T. Valko
|
3 |
204 |
|
|
|
|
4 |
162 |
|
|
|
|
1 |
162 |
|
|
find and replace data by
Rob
How would I find and replace data conditionally. In the example below I
would like to take Workbook 2, A1:A3 and replace abc with 123. Something...
|
September 23rd, 2008 12:54 AM
by NoodNutt
|
3 |
153 |
|
|
Convert time to text by
NoodNutt
G'day Everyone
I need a work around for the following please:
Case Target.Value = DateSerial(2008, 9, 1) And Target.Value
DateSerial(2008, 10,...
|
September 23rd, 2008 12:52 AM
by NoodNutt
|
3 |
286 |