|
|
Save As with formulas by
Jackie
Hi Group,
I have 2 Excel files. One has a macro that reads through values in the
sheet and updates a formatted Template with these values. The...
|
October 6th, 2003 11:31 PM
by Danny 
|
1 |
616 |
|
|
lookup by
anna
I have a sheet that contains prices for products. These
products have sku numbers.
Some of the products prices get updated monthly while
some prices won't...
|
October 6th, 2003 11:52 PM
by Tom S.
|
1 |
127 |
|
|
|
A time formula question by
Kyle
Hi, i want to calculate the difference between Cross
Country Times. Ex: Race1: 25:13 (thats 25min. 13sec.)
Race2: 26:45 (thats 26min. 45sec.) I know thats...
|
October 7th, 2003 12:04 AM
by Dave R.
|
2 |
183 |
|
|
|
Pivot table formulas by
Alan
Hello -
I am using XL2002. I have a pivot table and I was to include a simple
division formula. The table has a customer and sales info for 2001 and
2002. ...
|
October 7th, 2003 01:26 AM
by Alan
|
5 |
281 |
|
|
|
printing gridlines by
Stewart Patterson
When I check 'gridlines' in 'print preview', my Excel 97
no longer shows gridlines in the preview, or prints
gridlines in the output. Is there a fix for this?
|
|
2 |
341 |
|
|
|
Click to select cell? by
Ralph
Using Excel XP with the latest patches. I have to click 3 times in a
cell to select the cell. I have toggled the TYPE DIRECTLY IN CELL
function and compared...
|
|
2 |
258 |
|
|
|
|
October 7th, 2003 02:26 AM
by RagDyer
|
2 |
572 |
|
|
|
Spam by
Mike
I posted a message on this site a couple of weeks ago.
Since posting that message I have received a ton of
spam. This is the only site I have posted my...
|
|
2 |
127 |
|
|
|
Subtotal Mystery by
EU
I added added a SUBTOTAL with COUNTA sub_function
=SUBTOTAL(3,range) and it counts ALL cells in that range
instead of just the non-empty ones. So, if there...
|
|
4 |
185 |
|
|
|
random number generator formula by
Dave R.
Have you used the RAND() function?
If i remember right, it may not be installed automatically so you might have
to add it on. But then just use RAND() next to...
|
October 7th, 2003 04:02 AM
by Max
|
1 |
371 |
|
|
|
Excel Cell Limitations by
JD Kronicz
Hi
I am trying to create a large cell in Excel so that people can type
many paragraphs of information. I have done this by merging a number
of cells together...
|
|
3 |
262 |
|
|
|
|
|
3 |
346 |
|
|
|
Time Sheet function by
John Logan
I need assistance constructing a time sheet for
department employees.
Is it possible to calculate regular time AND overtime from
time start and time end?
In...
|
|
3 |
756 |
|
|
|
|
|
3 |
587 |
|
|
|
Sumproduct clarification by
Walter Mayes
Various members of this forum have stated that the arrays used in
SUMPRODUCT must be the same.
Excel HELP says, under remarks, in part..."Array arguments must...
( 1 2)
|
|
18 |
442 |
|
|
|
Relative Links by
David
I am using an xl spreadsheet as a front end to link data
to other spreadsheets in the same folder. I have no
problem creating the links and getting the...
|
October 7th, 2003 11:28 AM
by David
|
0 |
614 |
|
|
|
Arrays by
Bernard V Liengme
Hi Jan
Assuming you have an extra 0 in the example, this works for me in C1 enter
=MATCH(A1,$B$1:$B$2,0)
Copy down to C8
Best wishes
Bernard
"Jan"...
|
October 7th, 2003 03:10 PM
by Jan
|
1 |
135 |
|
|
|
Floating cells by
sanjay
I need some help with excel and I was wondering if you
could aid me in this regard.
I need to create a floating cell(if that is the right
name) in excel. The...
|
|
1 |
163 |
|
|
|
Erro message while using move and copy by
Joyce Johnson
I get the error message "No more fonts may be applied in
this notebook" when I try to copy a new spreadsheet. I
need a total of 16 sheets and after 12 I get...
|
|
1 |
168 |
|
|
|
Columns by
Mark
My colums changed from letters to numbers. Do not know
why. I want hem to be letters. All my worksheets changes.
|
October 7th, 2003 04:12 PM
by Jim
|
4 |
154 |
