|
|
Pivot table active dropdown by
rickdluc
I have a pivot table set up with 4 drop-down fields. Is it possible to set up
these fields so that the selection from the first drop-down restricts the...
|
September 3rd, 2008 08:23 AM
by rickdluc
|
5 |
386 |
|
|
match formula question with isna by
Belinda7237
I need to match using two columns - this doesnt see to be working:
=IF(ISNA(MATCH(I11&J11,'Projected MCE Report Northern C'!I:I &'Projected MCE
Report...
|
September 3rd, 2008 03:53 AM
by T. Valko
|
1 |
119 |
|
|
Formula copies when only answer is wanted by
Rhino721
Excel 2003, When I copy a group of cells with a formulas in them. The
formulas copy and try to adjust to match what they were before. I only want
the sum of...
|
September 3rd, 2008 03:51 AM
by Rhino721
|
2 |
97 |
|
|
if formula - multi criteria by
Belinda7237
I want to be able to place an x in a column only if three criterias are met:
currently in column 0 i have a number of days past due - if column O is
between...
|
|
6 |
112 |
|
|
Conditional Function by
SluMark
I am trying to calculate overtime hours, but I do not know how to program it.
Something like: IF B3 = 8, then C3=0 If B3 8, then C3 = Amount Greater...
|
|
2 |
74 |
|
|
|
|
1 |
67 |
|
|
Can Anyone Help me with this by
Kinghart
If b2 is 60 and d2 is =0 then g2 = "Bingo"
If b2 is 60 and d2 is =0 then g2 = "Bingo"
If b2 is 60 and d2 is 1 then g2 = "Sorry"
--
Kinghart
|
September 3rd, 2008 02:43 AM
by smartin
|
8 |
82 |
|
|
Help by
huskym1025
I need a formula that will take the amount of "ounces" I put in one
range of cells and in another range of cells I need the "ounces" to be
totaled.
Like...
|
September 2nd, 2008 11:57 PM
by JMB
|
3 |
74 |
|
|
lookup function by
Clinton
I need to lookup and insert values from sheet 1 into sheet 2. names are not
always alphabetical and can change order.
a b
1 name ...
|
September 2nd, 2008 11:51 PM
by Clinton
|
2 |
82 |
|
|
Max function by
Tuppie11
Here is a subset of a group of data that I have:
Name Date Dealer Sales
Andrea sept-07 A 10
Andrea sept -07 B 14
Tom ...
( 1 2)
|
September 2nd, 2008 11:19 PM
by T. Valko
|
13 |
108 |
|
|
date formula by
bill2
Hi,
How do I write formula for a 8 digit date without / so that it appears as a
8 digit number: ie, 2/12/99 as 02121999?
Thanks!
|
|
1 |
51 |
|
|
Non Prinatble fill by
Levon
I need to make a form for people to fill in. I want to either highlight the
fillable areas or black out everything but the fillable form areas. I do not
want...
|
|
1 |
53 |
|
|
Count if with multiple column criteria by
JPS
I have multiple columns in a spreadsheet and I need to count the number times
column D contains “TBN” when column L is equal to 1
Thanks.
--
JPS
|
September 2nd, 2008 10:46 PM
by Max
|
7 |
87 |
|
|
Formatting Excel by
Golfer Guy
I need to add cells together based on their background color or font color.
(I only want to add the cells that are red) How do you do this? I know no...
|
|
4 |
65 |
|
|
2003 macro generates compiler error on 2007 by
KenInPortland
The following macro works fine in Excel 2003 but generates a compiler error
on 2007. Any ideas or direction?
Sub WhoRang()
Dim ButtonLabel As String
Dim...
|
|
2 |
121 |
|
|
|
September 2nd, 2008 09:44 PM
by Spiky
|
4 |
92 |
|
|
|
|
2 |
88 |
|
|
Formula to determine 10 business days by
OfficeManager
Can anyone help me with a formula to determine a date that will be 10
business days from today's date? I am working on a form and I would like
have a cell...
|
|
2 |
53 |
|
|
|
|
6 |
61 |
|
|
Menu Delete greyed out by
Helper
Office 2003 SP3. On all worksheets, my Edit - Delete command is grayed out
(unavailable). I can't delete a row or column. None of the workbooks are
protected...
|
September 2nd, 2008 09:13 PM
by Helper
|
0 |
59 |