|
|
|
|
5 |
905 |
|
|
Excel 2007 Pivot Tables by
Marsh
1. How can I create a Pivot Table from a text file, downloaded from a
mainframe database? I have been told this could be done in previous versions
of...
|
|
1 |
905 |
|
|
|
|
6 |
903 |
|
|
Save as Web Page in Excel 2002 by
Bob
Is there any way to "tone down" the code that Excel 2002
creates when saving a worksheet as a web page? We
converted to Excel 2002 this past year at work and...
|
June 23rd, 2004 02:49 PM
by Brad
|
1 |
902 |
|
|
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 |
900 |
|
|
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 |
898 |
|
|
search for a string by
santana
How can I search for a string (“Draft Documents”) in sheet1 and then delete
all the rows above the row containing the string and then delete the last two...
|
|
1 |
898 |
|
|
e Mail attachment by
La Blonde
I received an attachment recently, which, when I opened it, appeared as
gobbledegook- I have Windows xp and Offfice 2000 & it seems the attachment
was...
|
|
3 |
898 |
|
|
|
|
1 |
896 |
|
|
=if formulae by
Janie
I have and excel spreadsheet which I wish to record an error message if one
cell as a value of more than zero and the cell below it has a value of zero.
I...
|
|
2 |
896 |
|
|
|
|
0 |
896 |
|
|
formula for copy and paste by
robbie5
can i create a condtional function in a cell that would send data in one row
of cells to a cell in another worksheet.
ex
a1
a2= aaaa
a3= bbbb
a4=cccc
a5=if a1...
|
December 27th, 2005 09:59 PM
by bpeltzer
|
2 |
895 |
|
|
No zoom to page option ??? by
Blue Max
Doesn't Excel 2007 have an option to quickly zoom to the full page, the
width, or the height?
Most current programs provide quick menu options or toolbar...
|
|
5 |
895 |
|
|
New To Formulas - Help please by
kirstikate
This is probably very easy, but im having trouble - I want to find a formula
that does the following
IF H49 + G49 = F49 and F49=I49 then True If it...
|
May 25th, 2010 09:05 PM
by Brad
|
6 |
895 |
|
|
|
|
3 |
894 |
|
|
Resetting cells to zero value. by
Ron
I have lots of cells with numbers. Can I place a button that will reset all
cells to zero?
Right now, when I want to start over, I go to each cell and change...
|
|
4 |
894 |
|
|
|
|
3 |
893 |
|
|
Comparing, Matching, and Sum formula by
ma
Hello.
Column A has dates. The format is 2010-04-29. There are multiple rows with
the same date.
Column B has numbers
Please, provide me the formula IF:...
|
|
6 |
889 |
|
|
EXCEL by
Harold Dennis
Save more than 10 pages in order and then keep in folder for use the
next day?
|
|
2 |
889 |
|
|
Header by
Belin
I am new to this Excel 2007 and don't know how to put a title where the
lettered columns are. I need it to be centered across 4 columns. Thanks for
the help
|
|
1 |
889 |