|
|
Copy and Paste Conditional Sum Formula by
David Kinkella
Is it possible to copy and paste a conditional sum formula
to a different cell location and then change the = to
value in the IF( portion of the formula?
I...
|
September 20th, 2003 01:18 AM
by Biff
|
1 |
839 |
|
|
superimposing an object by
Lacreeda
I would like to be able to superimpose a 25% gray "Draft"
to draft documents. Any idea how to accomplish this?
TIA Lacreeda
|
September 20th, 2003 01:03 AM
by Jim
|
1 |
169 |
|
|
Invoice Template; date problems by
Annalee
I want to stop the invoice template from prefilling
today's date everytime it opens an invoice. Does anyone
know how to do this?
|
September 20th, 2003 12:40 AM
by Annalee
|
0 |
392 |
|
|
|
September 19th, 2003 11:52 PM
by Ed
|
1 |
351 |
|
|
Rename Worksheets with Macro by
Eric Larsen
I would like to have a Macro to go to a certain cell to rename a worksheet.
When I run I get errors.
Can someone lend a hand?
|
|
2 |
229 |
|
|
Date Time Stamp by
Galsaba
I would like to add a field, or a column that will indicate the date and time
that the corresponding row has changed.
For example, I have the following...
|
|
3 |
181 |
|
|
question about panes by
David Shore
If I divide my worksheet up into 2 panes, how do I perform "unsynchronized
schrolling"
Thanks
|
|
2 |
148 |
|
|
|
|
1 |
251 |
|
|
Tally Text by
Sally
Thank you for your help
I used the formula you suggested and I'm getting the
#VALUE! error - Any suggestions?
-----Original Message-----
One way would be...
|
September 19th, 2003 11:00 PM
by Dave
|
1 |
311 |
|
|
Macros by
Kristine
We have a worksheet with macros and every time I try to
run them the following error occurs with name of the doc
in the brackets.
macro error at...
|
September 19th, 2003 10:22 PM
by Ed
|
1 |
114 |
|
|
columns to rows by
Brenda
Hello all:
I need to rearrange my columns into rows. I've got
column headings like this:
Heading1 - Heading2 - Heading3 - Heading4
Data1 - Data2 -...
|
|
3 |
321 |
|
|
Formulas by
Lisa Crain
This is driving me crazy! If I want to "lock" a cell in a
formula so that Excel goes back to that same cell when I
copy the formula how do I do that?
For...
|
|
2 |
127 |
|
|
COVAR by
Dan
I am having trouble reproducing the values produced by the
Data Analysis tool that calculates a variance-covariance
matrix. When I try to calculate one cell...
|
|
4 |
183 |
|
|
Search Function by
saad
Hi,
I have a list of cities (more than 2000) stored in a
column. What I am trying to do is for a user to enter the
first few characters of a city in cell A1...
|
September 19th, 2003 07:54 PM
by saad
|
3 |
386 |
|
|
|
|
1 |
538 |
|
|
Close unchanged file by
Barb
I opened a file. Did not make any changes. When I close
the file, I receive a message asking if I want to save
changes to the file before closing. I didn't...
|
|
1 |
154 |
|
|
placing a null value using IF by
Dick Minter
The IF function may be used to place a blank value in a
cell based on a criteria.
Example: =if(iserror(vlookup(a1,table,2,false)),"",vlookup
(a1,table,2))
The...
|
|
1 |
181 |
|
|
|
September 19th, 2003 03:07 PM
by steve
|
0 |
898 |
|
|
Filter drop down menu font size by
Jim Sullivan
When I filter my spread sheets and then try to access the
alternatives in the drop down menu the font size takes the
text outside of the field of view. How can...
|
|
0 |
715 |
|
|
Conditional Sum by
Brussels 007
I have 3 columns in XL, A, B and C.
A and B contain variables like region code for A and salesman ID for B
In C, I have amounts.
I would like to add amounts...
|
|
1 |
116 |