|
|
|
August 6th, 2008 08:18 PM
by Atilla
|
3 |
85 |
|
|
|
August 6th, 2008 08:16 PM
by Mike H
|
1 |
85 |
|
|
Formula Error by
roxiemayfield
I have the following formula with an error. I am trying to get an na to be a
-0- if the lookup is...
|
August 6th, 2008 08:12 PM
by Mike H
|
3 |
85 |
|
|
|
|
15 |
195 |
|
|
adding function to an existing formula by
chickenita
I am an excel virgin, so please bear with me! I have an existing formula, I
would like to divide the subtotal by 2, how would I do that?
--
anita
|
|
2 |
101 |
|
|
Adding Day to find a next weekday by
Dolt
Ok, I am trying to create a function that does the following..
Adds X amount of days to a particular day including ALL days but returning a
result that is not...
( 1 2)
|
August 6th, 2008 07:31 PM
by gafern
|
12 |
148 |
|
|
convert yyyy-ww date to actual date by
Pierre
Have a string of dates of produced items. All the dates are mmmm-mm
(2007-06), for the 6th week in 2007 for instance. Looking for a
formula to have it enter...
|
August 6th, 2008 07:02 PM
by Pierre
|
2 |
100 |
|
|
|
August 6th, 2008 07:02 PM
by Pete_UK
|
4 |
101 |
|
|
IF Statement by
Libby
I have a list of 266 budget numbers and I want to create a formula that will
translate the four diget code into the name of the program. I've started with...
|
|
6 |
83 |
|
|
|
|
14 |
169 |
|
|
precentage formula by
Dphel
I have 2 dollar amounts, for example $44,850.00 and $33,658.60, I need a
formula that will tell me what the precentage is for the difference between
both...
|
|
3 |
127 |
|
|
SUMIF by
Mike
Please assume that my data will look like...
|
|
1 |
71 |
|
|
|
|
1 |
88 |
|
|
column subtotal by
Mel
I use subtotals with filters to total piece work on different employees.
When I open the file each time it makes me reclick the boxes I want
subtotaled...
|
August 6th, 2008 04:38 PM
by Mel
|
0 |
68 |
|
|
Excel 2003 by
lindle101
I am trying to open delimited data in Excel. When I do, my part numbers (in
this case, some with a dash) turn into dates. Is there a default I can turn
off...
|
|
4 |
77 |
|
|
|
August 6th, 2008 04:17 PM
by Alvyn
|
2 |
91 |
|
|
Cross-sheet formula and sort data by
smuggy
Not sure if this is a new issue with Excel 2007 or if it was there before.
When entering a formula into a worksheet (call it Sheet1), I firstly clicked
open...
|
August 6th, 2008 04:15 PM
by smuggy
|
0 |
58 |
|
|
Using lookup formula by
[email protected]
I need to find a value in a table where value in Column A = "example"
and date across Row 1 = "Aug-08". I am summarising data in a simple
table in my first...
|
|
2 |
82 |
|
|
Copy custom footer across multiple sheets by
Clark
Does anyone know how you can copy page settings across multiple pages?
Example: margins and custom footers from one page in a file to the rest of
the pages...
|
August 6th, 2008 03:59 PM
by Pete_UK
|
3 |
93 |
|
|
|
August 6th, 2008 03:28 PM
by JP[_5_]
|
1 |
105 |