|
|
nested formula help needed by
My experience is Yes, you are limited to seven nested
functions.
But my question is, do the functions really need to be
nested? I ask this because I received...
|
October 14th, 2003 04:17 PM
by
|
0 |
367 |
|
|
|
May 13th, 2004 07:45 PM
by
|
0 |
1,608 |
|
|
Referring to form controls in formula by
How do I reference a form control in a formula? Example:
I have a list or drop-down box on an Excel form with
values A, B, C, etc. How would I reference the...
|
|
1 |
88 |
|
|
copying Text by
how can i set a cell on sheet 2, to copy text from sheet 1
and if the cell on sheet 1 is blank then so is the cell on
sheet 2.
|
July 13th, 2004 03:13 PM
by
|
5 |
99 |
|
|
|
July 13th, 2004 04:27 PM
by Andy B
|
2 |
129 |
|
|
Would use Array formulas but.... by
I am studying examples of array formulas just to get the
feel of them so I can use them when needed. But the
message I get when entering the formula...
|
|
3 |
310 |
|
|
Macros disabled message by
Sometimes I get this "Macros Disabled", but sometimes I
don't. I'm getting it right now, and it's driving me
crazy, how do I get rid of it?
|
|
2 |
315 |
|
|
|
|
5 |
279 |
|
|
Link Cell to header and footer by
Is there a way to link part of the footer information to a
cell in a spreadsheet? Someone I work with wants to have
control over updating the revision date...
|
|
1 |
174 |
|
|
Spell check and protected worksheet by
Does anyone know how to enable spell check when a
worksheet is protected? I've tried a number of different
options, but whenever I protect the worksheet I...
|
April 8th, 2004 09:23 PM
by
|
2 |
388 |
|
|
How to determine duplicate records by
Hello there!
Anybody could help me?
I want to know if there is a way I could determine a
duplicate entry about 10000 records becuase i do it
manually:
for...
|
March 23rd, 2004 03:51 PM
by
|
0 |
147 |
|
|
Transpose Worksheet by
I have a worksheet that is two hundred rows long and uses
every column in the worksheet. I have several more
columns to enter so I need to switch the columns...
|
|
1 |
132 |
|
|
error bars excel97 by
G'day,
I am wanting to add error bars to a graph. I looked
up help and it said to select the data series, go to the
format menu and click data series. but when...
|
October 19th, 2003 02:46 AM
by Scottmk
|
1 |
150 |
|
|
|
December 12th, 2003 03:16 PM
by akyurek
|
2 |
233 |
|
|
|
December 12th, 2003 05:25 PM
by Paul
|
2 |
267 |
|
|
How to lock one cell in formula? by
There are two types of cell references -- relative and
absolute. When a relative cell address in a formula is
copied, the actual address is modified to...
|
December 26th, 2003 01:22 PM
by orlando
|
2 |
549 |
|
|
Alignment by
Thanks Frank - your solution works a dream
Steven.
-----Original Message-----
Hi Steven
try the following custom format
0.????
use as many '?' as you...
|
|
1 |
120 |
|
|
lookop or index? by
I'm looking for a way to look up/return a value based on 2
nubers like below:
I need the balance for Account 57500, & Cost Center 125
from a trial balance...
|
March 12th, 2004 05:19 PM
by Dave R.
|
4 |
86 |
|
|
Mouse is scrolling slowly by
Hi Guys,
I have had excel 2002 before and just picked up 2003 and
in my excel sheets scrolling is very slow whenever i
scrolling in an empty or full...
|
March 28th, 2004 09:18 AM
by
|
0 |
510 |
|
|
#DIV/0! by
I've got a YTD spreadsheet that will be fed each month
from monthly spreadsheets... In some of the cells within
the monthly spreadsheets it is #DIV/0!... As...
|
|
1 |
148 |