|
|
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 |
|
|
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 |
|
|
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 |
|
|
|
|
2 |
331 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
"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 |
753 |
|
|
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 |
|
|
|
|
2 |
752 |
|
|
|
April 28th, 2004 09:31 PM
by Jiombo
|
2 |
562 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
|
April 29th, 2004 08:07 PM
by SidBord
|
5 |
469 |
|
|
|
|
2 |
384 |
|
|
finding double payments by
Monique
Imagine an excel file with two collumns, the first one contains the
vendor number, the second one the payment amount. The excel file
contains all payments made...
|
April 29th, 2004 10:43 PM
by Dave R.
|
1 |
445 |
|
|
formula to caculate an age by
Gayle
I am needing a formula that would figure out the age in
years and months of a specfic person.
For example
Date of Birth is 7/27/1999 and the date is 10/23/2004...
|
|
1 |
390 |