|
|
Duplicate Worksheet by
powrus
A new software program insisted I change my desktop resolution to a higher
setting than I've used for years. I did so, which in turn gives me a broader...
|
August 4th, 2008 07:54 PM
by powrus
|
2 |
63 |
|
|
|
August 4th, 2008 07:26 PM
by John
|
2 |
86 |
|
|
|
August 4th, 2008 06:13 PM
by JaxHBT
|
5 |
165 |
|
|
Functions for inventory by
J-LL
The boss wants an inventory count of cars on any given pass date. The
existing table has a DELIVERED date field, for when the car is entered in
inventory;...
|
|
9 |
113 |
|
|
SUM function settings by
George[_18_]
Hello
The SUM function allows up to 30 numbers to be added
=SUM(number1;number2;;;numbern;;;number30). Is there a way to modify
the settings of this function...
|
August 4th, 2008 04:56 PM
by RagDyeR
|
4 |
95 |
|
|
|
August 4th, 2008 04:47 PM
by RagDyeR
|
6 |
96 |
|
|
|
August 4th, 2008 04:46 PM
by RagDyeR
|
10 |
212 |
|
|
Setting a minimum currency value by
George
Hello,
I have a locked worksheet distributed to users where they insert certain
values. One of the fields is for currency and I want to code it so that it...
|
|
3 |
92 |
|
|
Excel Formula Help by
kwall
I need help creating a formula. I have an Excel 2003 Worksheet that contains
information. I would like the formula to look at the column ProductID where...
|
August 4th, 2008 04:38 PM
by Pete_UK
|
2 |
83 |
|
|
Turn off auto sequence in fill down? by
Pierre
Want to fill down with the mouse without going to the next number in a
sequence;
IOW:
If A1 is E76D3456-1, I want to copy down using the mouse without
having...
|
|
5 |
77 |
|
|
Auto Lookup and Populate by
CB
Name Jan-2008 Feb-2008 Mar-2008 Apr-2008 May-2008 Jun-2008
Big Blue X
Above is an example of the spread sheet I am trying to populate. What I need
to do...
|
August 4th, 2008 04:10 PM
by CB
|
0 |
83 |
|
|
Need to add to nested IF by
sernst
I'm brain dead and tired of looking at this.
I need to add this primary condition: IF($BH11=0,0,...
to this...
|
August 4th, 2008 04:08 PM
by sernst
|
4 |
147 |
|
|
INDEX OR INDIRECT by
JBoyer
=IF(COUNTA(INDEX(F:L,ROWS($1:20)*5-97))=0,"",SUMIF(INDEX(F:L,ROWS($1:20)*5-97),"0"))
The function above is what I want in cell T20. It works fine until I run...
|
|
6 |
117 |
|
|
|
|
2 |
100 |
|
|
Restrict Data Values Allowed by
Gina[_3_]
I have possibly screwed up in a big way.
In my spreadsheet I have assumed that records would be added chronologically
(as they should), and did not allow...
|
|
8 |
99 |
|
|
Autosum of various cells by
Dors1309
Hi
I have the following cells
D1 = GRAND TOTAL (including E1, F1 and G1 amounts)
E1 = 10% of D1
F1 = 7% of D1
G1 = 5% of D1
When I put a figure into D1 I...
|
|
2 |
83 |
|
|
dynamic range and chart - big help!! by
Xaraam
hey!!
i'm working now with dynamic range for single column and charts.
i've a chart with number on the y axis and dates on the x axis and i would
like to...
|
August 4th, 2008 12:01 PM
by Xaraam
|
3 |
117 |
|
|
Printout using MFC by
Sachin
Hi All,
When i am writting
worksheet-Printout( parameters )..
Its showing dialog box for few seconds. How to avoid it?
Regards,
Sachin
|
August 4th, 2008 11:25 AM
by Sachin
|
0 |
91 |
|
|
|
|
0 |
115 |
|
|
|
August 4th, 2008 03:12 AM
by Keith
|
3 |
77 |