|
|
autosum by
is it possible to autosum from 2 different sheets
|
October 2nd, 2003 07:50 PM
by Paul B
|
1 |
185 |
|
|
Summing Filtered Rows by
Ok, I've filtered my spreadsheet using AutoFilter and
selecting one of the availble cell contents as a criteria.
Now that I've got a table that shows only the...
|
|
4 |
145 |
|
|
Formula by
agian you can use the vba function: "Worksheet_Change"
each use you change CELL this function will be activated
and put in the target cell the output.
For...
|
April 21st, 2004 07:22 AM
by
|
0 |
78 |
|
|
|
April 28th, 2004 03:42 PM
by
|
0 |
802 |
|
|
Find the 5 max values in a column? by
Any one know of a way to:
On a column: Formated as numeric
Return the Max(thats the easy part and the "max" function
will do that), and the next 4 values (ie...
|
|
3 |
229 |
|
|
VLOOKUP by
Randy wrote:
in the range that contains the lookup value, there are
multiple or duplicate entries, is there a function or
formula that gives all...
|
|
1 |
126 |
|
|
formula help by
i need some help please. I know a little bit about excel,
but im having some trouble combining formulas.
this is what is in cell...
|
July 8th, 2004 10:21 PM
by
|
4 |
96 |
|
|
|
July 12th, 2004 06:29 AM
by bigt
|
2 |
299 |
|
|
|
July 12th, 2004 04:35 PM
by MikeC
|
2 |
107 |
|
|
Is anyone bright enough to help? by
Let me clarify. I am trying to transfer data from an
excel 2002 cell to a specific place in a word 2002
document. I am not trying to cut/copy and paste. I...
|
March 12th, 2004 02:13 AM
by JulieD
|
5 |
218 |
|
|
Got me stumped by
I have an Excel Report that was generated by ODBC. I was
asked to customize the report so that company numbers on
one sheet would look up into another sheet...
|
March 11th, 2004 06:21 PM
by CMG
|
2 |
107 |
|
|
simple function by
Hi, I have a simple function to figure out but without
much experience. I hope someone will answer.
Let's say I have two columns A & B. I want a formula...
|
October 15th, 2003 08:40 PM
by
|
7 |
119 |
|
|
enter a null or "blank" value in a cell by
How do I get an Excel Function to place a NULL value in a
cell vs. a blank or space. Here an example: Cell A1
contains the number 11, when I enter the formula...
|
|
1 |
505 |
|
|
Blanks vs. Null values in Functions by
How do I get an Excel Function to place a NULL value in a
cell vs. a blank or space. An example: Cell A1
contains the number 11, when I enter the formula...
|
October 17th, 2003 12:02 PM
by Paul
|
1 |
556 |
|
|
Random Number Generator - Help! by
Any and all help is appreciated.
Starting in Cell B7, I have a list of names. In E7 is a
sequential number (starting at 1) that is associated with
each name....
|
|
3 |
307 |
|
|
workdays by
i searched the archives but and I know its there but
couldent find it. I need to only include only workdays in
my formula (m-f)
|
December 16th, 2003 08:28 PM
by
|
1 |
97 |
|
|
Cell Format by
Thanks again.
Any idea what this one is doing and how to fix it?
I insert 90014E04 and Excel converts it to a scientific
number 9.00E+08
Any idea what the...
|
|
1 |
387 |
|
|
formula not calculating correctly by
The formula in the third column is =L8/M8. I have the
third column formatted as Percentage with no decimal
positions. As you can see the cells with an...
|
|
3 |
219 |
|
|
AUTO ADDITION by
I AM LOOKING FOR A WAY TO HAVE EXCEL AUTOMATICALLY DO
SOME MATH FOR ME. FOR EXAMPLE, IF I TYPE 25 IN CELL B4, I
WANT IT TO AUTOMATICALLY ADD 25 TO IT. ANY...
|
|
4 |
133 |
|
|
|
|
3 |
126 |