|
|
|
|
1 |
512 |
|
|
Excel 2000 pPaste special features. by
Maurice
I need to add Biff3 and sylk formats in the excel 2000
paste special options do anyone know how to add these add-
ins? Thanks in advance
|
|
1 |
567 |
|
|
Cut and Paste by
Chris from Waterworks
Hi all. How can I cut and paste a formula that retains the same formula. Every time I do it the cell references change. While this is a nice feature in some...
|
|
3 |
332 |
|
|
Format for 3 D reference by
Dan
When referencing a cell in a worksheet in another worksheet, is there a way to have the formatting from the referenced cell automatically be the same in the...
|
|
6 |
507 |
|
|
SUMPRODUCT with YEAR, MONTH functions by
Attila Fust
I am trying to sum data if a date range matches (year and
month only). Here is the example:
Table1
5/15/00 5/16/00 6/17/00 (NAME=DATES1)
5 5 ...
|
|
5 |
578 |
|
|
Counting in Excel by
bcollie
I know nearly nothing about Excel syntax, so please be kind.
I have a list of people who are eating at a seminar. So far I have
some blank cells, some N for...
|
|
1 |
368 |
|
|
small worksheet names by
paul.young.b \(no spam please\) @bayer.com
I have user that has his monitor resolution set high and
then goes in and adjusts the size of the cells to
accomodate what he is doing. When he does this, the...
|
|
3 |
427 |
|
|
Finding duplicate names by
Matt in AZ
Thanks. That worked great!
--
Matt in AZ
"Max" wrote:
Try this ..
Assuming the data in cols A and B are in row1 down
|
June 14th, 2004 08:18 PM
by Max
|
1 |
1,100 |
|
|
Using ranges as lists by
jasonp
Trying to use the IF statement to compare a user's input into a cell to another cell and give the value of a cooresponding cell.
i.e. a1=if(b1=c1,d1,0)
mileage...
|
|
1 |
336 |
|
|
|
|
2 |
450 |
|
|
Sum field N times by
Sara Jane
I would like to sum a specific cell N times. Is there a
command to execute this? As I am VBA inept, I am hopeful
it can be done without the use of...
|
|
1 |
345 |
|
|
Macro when a font in a range changes by
whisperinghill
Actually, I just completed a vb code to monitor a dde link and
automatically sends an email. It only send s the email whenever the
dde link passes through a...
|
|
0 |
859 |
|
|
ALL CAPS to Proper! by
a little help please
I'm having trouble making a very long list of names and adresses go from ALL CAPS to Proper. Any suggestions would be helpful.
|
|
1 |
459 |
|
|
Iterative Calculation help needed by
rkerbrat
I have the following information
A1 - Balance at the beginning of calculation
A2 - Annualized payment
A3 - Interest rate divided by # of payments per year
A4 -...
|
|
3 |
449 |
|
|
|
|
4 |
527 |
|
|
querying excel spreadsheets like database by
corrie
I'm making a payroll journal, it has a column for the names, and then
the cheque amt, cheque no., and some other stuff.
In a separate sheet I need to pull up...
|
|
1 |
547 |
|
|
|
|
1 |
707 |
|
|
|
|
5 |
882 |
|
|
Error opening or copying Excel File by
Miscell04
I have a disk which I received from someone outside my
office. The disk contains xls and WQ1 files. When
attempting to copy the disk I get the following error...
|
|
1 |
685 |
|
|
V-lookup of file names? by
jeff
I don't know if this is possible, but I thought it would
be worth asking.
Is there a way to do a vlookup of a file name in order to
open the file and then...
|
|
1 |
594 |