|
|
|
April 29th, 2004 08:07 PM
by SidBord
|
5 |
469 |
|
|
Function problem by
Nigel Heald
Hi
I am trying in vain to find a function within Excel 2003 that will enable us
to calculate the monthly investment required to achieve a given amount after
X...
|
|
1 |
425 |
|
|
counting rows by
ed
I suspect this is relatively easy but I'm not sure how to accomplish this. Is there a way to count the "non blank rows" in a specific column. We need to know...
|
|
1 |
437 |
|
|
copy a formula by
Mark Kennedy
I want to copy formulas without changing the cell references and not
relative without the $ signs.
Example: In C1 I have =A1+B1 (actually mine is complex). I...
|
|
4 |
352 |
|
|
Designing a question paper by
Ken
Could anyone please help. I am relatively new to Excel and am trying to
design a question paper where the student has to fill in the answer box.
What I would...
|
April 28th, 2004 10:13 PM
by Ken
|
2 |
1,061 |
|
|
|
April 28th, 2004 09:31 PM
by Jiombo
|
2 |
562 |
|
|
|
|
2 |
752 |
|
|
As I type in the Formula Bar it blinks by
daniel
I work with Excell 2002 and as I type in the Formula Bar
it blinks and trembles. The problem gets worse as the
text becomes longer. That makes it impossible to...
|
|
1 |
496 |
|
|
"tip" sheet by
Pete
Does anyone know if Microsoft offers (for purchase) a laminated "Tip" sheet showing commonly used functions, formatting, etc? I know they offer one for...
|
|
3 |
755 |
|
|
auto numbering 1,2,3,... by
Richard
I tried ctrl drag and got nothing. I could have typed them in by now but I would learn nothing THX!
|
|
3 |
348 |
|
|
excel '97 freezing up on xp by
Ivan
Is Excel '97 supposed to work with Windows XP. Ever since I've had my new
computer with XP, my excel '97 is very buggy. Almost every time I make up
even the...
|
April 28th, 2004 02:24 PM
by BrianB
|
2 |
477 |
|
|
cannot print certain row of sentence. by
dave ong
hi,
I am using Windows 98 SE, and also MS Excel 2000. I have a
problem when some of the row cannot print out, while the
sentence before and after the row can...
|
April 28th, 2004 02:19 PM
by BrianB
|
1 |
388 |
|
|
auto updating a worksheet by
erika
i am trying to update info in a worksheet and i simply don't know how. okay say for instance i have a grocery list that displays the product,price,how many and...
|
|
2 |
524 |
|
|
|
|
2 |
331 |
|
|
Please help, I know nothing by
amme
I am a very new at this and it is driving me crazy.
For example, I want to add all of column A + column B and I want the answer to go in C. I want this action...
|
|
4 |
444 |
|
|
Finding Minimum value by
Ruan
Hello,
I know the formula for finding the minimum value in a range is
=MIN(G7:G31)
But how do you find the minimum value and ignore all the 0...
|
April 27th, 2004 08:50 PM
by Ruan
|
4 |
517 |
|
|
View Duplicate entries by
Ruan
Frank,
That formula work great, but when you are tagging duplicates where the range
has formulas in them, then the formula ends up getting tagged as a...
|
|
3 |
657 |
|
|
Find & Replace in XP by
Jane
XP now has the ability to do a find & replace based on
formatting, but i ran across an issue. If I type the word
accountant in cell A1 and "accountants are...
|
|
3 |
895 |
|
|
Finding maximum value by
Ruan
Hello,
I want to find the maximum value in a column, but I want to ignore the
negative and positive part of the value. Basically, the maximum difference
from...
|
|
3 |
891 |
|
|
Circular reference error by
Linda
Hi Guys,
Using Excel 2000. I have a workbook that is already saved. When I open the
workbook I get this error.
MS Excel cannot calculate a formula. There...
|
April 27th, 2004 04:09 AM
by Linda
|
3 |
1,548 |