|
|
|
|
5 |
899 |
|
|
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 |
898 |
|
|
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 |
897 |
|
|
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 |
895 |
|
|
Looking up values in a table by
Aris
Hi,
How do you search for data from a table having 2 criterias?
Example:
Month Name Score
Jan John 3
Jan Mark 2
Jan Tom 4
Feb John 5
|
|
2 |
894 |
|
|
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 |
893 |
|
|
|
|
6 |
893 |
|
|
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 |
889 |
|
|
|
|
1 |
888 |
|
|
=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 |
888 |
|
|
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 |
887 |
|
|
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 |
887 |
|
|
|
|
3 |
886 |
|
|
|
|
3 |
886 |
|
|
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 |
886 |
|
|
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 |
885 |
|
|
|
|
0 |
884 |
|
|
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 |
881 |
|
|
Salary Reciept by
hikmat
I need to make a Salary Reciept for my office use, i have staff here and i
have to pay them. i need a strong Salary Reciept, so i can pay staff salary
and...
|
|
3 |
879 |
|
|
EXCEL by
Harold Dennis
Save more than 10 pages in order and then keep in folder for use the
next day?
|
|
2 |
879 |