|
|
|
|
1 |
169 |
|
|
Subtotal - Directorate by
David Iles
There is a function in Excel called Subtotals (accessible via the Data menu)
which is supposed to group together and subtotal rows of data. The function
can...
|
|
2 |
87 |
|
|
Rounding error in Stdev function result. by
David K
the function
=STDEV(1.4434,1.4434,1.4434)
gives
2.98023E-08
(at least on my computer using Excel 2002, sp3)
Is this just rounding error due to IEEE double...
( 1 2)
|
|
15 |
226 |
|
|
Creating user defined function by
David K.
Hello,
I use Excel 2002 and I will appreciate having a detailed
procedure of creating a new user defined function and
storing it in the personal.xls...
|
November 20th, 2003 07:24 PM
by David K.
|
0 |
357 |
|
|
Help with Conditional Format Formula by
David K.[_5_]
Hi,
How can I highlight cells in a list of numbers on Sheet1 where the number of
occurrences of that number on Sheet2 is not equal to 1?
Sheet1 has a list...
|
|
6 |
146 |
|
|
New Formula Idea by
david kenmuir
I would like a formula that can equate a letter with an number, add the given
range, but also not do anything if there is a blank cell...
for example if i...
|
|
0 |
87 |
|
|
IF Condition by
David Kennedy
hi if you could help me with this it would be great,
i have tried to use the nested IF condition to insert
numbers in a column beside a column of country...
|
|
2 |
153 |
|
|
Alphanumeric sort with mixed numbers by
David Kingsworthy
I have a worksheet with about 650 rows of data. I am
trying to sort by the leftmost column, a mixed-number
column in basically a list of part numbers.
I have...
|
|
1 |
621 |
|
|
Copy and Paste Conditional Sum Formula by
David Kinkella
Is it possible to copy and paste a conditional sum formula
to a different cell location and then change the = to
value in the IF( portion of the formula?
I...
|
September 20th, 2003 01:18 AM
by Biff
|
1 |
839 |
|
|
matching one value in a list of values by
David Kinsley
I'm trying to use excel as a compliance tool. I have one cell, where the
name is manually typed in cell M17. For this example, let's say that the
name used...
|
|
3 |
106 |
|
|
macro problem by
David Kuehl
I have created several marco's in Excel and they work
great when you map to the drive they are on and run them
normal. If you try to run them through Explorer...
|
|
2 |
137 |
|
|
How do I do this? by
David K[_5_]
How to get a calculation or formula to insert its result in another cell?
eg say I want B1 = A1 + 2. The standard way is to put '=A1 + 2' in cell
B1. I want...
|
|
3 |
76 |
|
|
3D Stacked Bar chart by
David L
I am looking for a way to show a 3-Dimensional Stacked Bar (column). Is
there a way to do that?
The top parameter (construction site) has six sub-parameters...
|
October 3rd, 2007 05:21 PM
by David L
|
0 |
89 |
|
|
|
|
1 |
72 |
|
|
Copy command greyed out by
David Lazor
After blocking text I can use Ctrl+C to copy but the copy
command under the edit menu is always greyed out. Cut and
paste are fully functional.
|
|
1 |
104 |
|
|
How to customize right-click menu on Excel? by
David Loh
How can I customize the menu that appears when I right-click the mouse
on a cell on Excel worksheet?
For example, I want to add the Auto Sum function on the...
|
|
5 |
332 |
|
|
Formula Question by
David M
Hello All,
Okay..check out this formula
=IF(ISERROR(VLOOKUP(M4,Test,10,FALSE)),"",VLOOKUP
(M4,Test,10,FALSE))
What this does is say okay look at this number...
|
May 5th, 2004 07:19 PM
by D.M
|
3 |
86 |
|
|
|
|
13 |
417 |
|
|
Combining Functions by
David M
Please help.....
=IF(ISERROR(VLOOKUP(G4,Tivoli,5,FALSE)),"",VLOOKUP
(G4,Tivoli,5,FALSE))
returns the word Infrastructure......
I want to use the mid...
|
|
3 |
178 |
|
|
Time Extraction by
David M
I tried to explain this one yesterday but I don't think I
was clear so I will try again....
I have columns on my worksheet that calculates the
duration of a...
|
|
5 |
773 |