|
|
|
|
1 |
53 |
|
|
text boxes disappear off screen by
mark gregory
hi,
i have set up a new workbook containing various text boxes, all of which
appear fine on my pc, and on of most of my colleagues' pc's.
but on some of my...
|
|
2 |
68 |
|
|
opening csv by
KeithMeister
I'm not convinced by these answers. I have a similar issue, which I will
explain.
One of our web apps (intranet) creates a csv file and parses it to excel....
|
|
3 |
80 |
|
|
Changing an entry from another worksheet by
Jennifer
I have a spreadsheet with data that I have protected. The data is entered via
another worksheet then sent over via a macro. I have some else using this...
|
|
3 |
118 |
|
|
|
|
3 |
109 |
|
|
|
|
1 |
143 |
|
|
Excel vlookup by
kiran
Hi All,
I have a values as follows
B C D
f1cagprp.p #N/A yfrcpent.p
f1caiq.p ...
|
April 4th, 2005 01:47 PM
by Kassie
|
3 |
137 |
|
|
|
|
1 |
100 |
|
|
|
|
1 |
113 |
|
|
copying formula by
JG
I need to copy the formula "=IF(MAX(Sheet2!B5:B200)(TODAY()-21),"not
due","due") in sheet1 from cell b2 to all the cells between b3 and b200. Each
cell should...
|
|
9 |
116 |
|
|
How do I print my adress list? by
Andreas
How do I print my adresslist on labelsheets?
In Excel i looks like this:
Cell 1 Cell 2 Cell 3 Cell 4
Name Adress City Citycode
|
|
2 |
103 |
|
|
Data Validation by
Esrei
Why does (not equal to)not work in the formula in
Validation
EX D81.5
D81.5 does work
|
|
1 |
78 |
|
|
|
April 4th, 2005 02:47 PM
by Dave O
|
1 |
90 |
|
|
Function question (probably easy) by
Dahlman
I'm working with four columns. the cells in my 4th column are going to be the
averages of the other three columns. If I copy my average formulay down the
whole...
|
April 4th, 2005 03:09 PM
by Dahlman
|
4 |
214 |
|
|
|
|
1 |
113 |
|
|
Workbook path by
nc
Hi
How can I return the full path of a template using VBA
and login name of windows XP using VBA?
Thanks
|
April 4th, 2005 03:37 PM
by nc
|
2 |
86 |
|
|
Zip & Email - VBA by
JohnUK
Hi, I need to zip a file that I am working on, then email
automatically. I can do the emailing bit, but can't do
the zip
The OS is XP professional, with Office...
|
|
2 |
89 |
|
|
|
|
1 |
105 |
|
|
average if zero by
Lori Hornick
I'm looking for a formula similar to the following, but one that works.
=average(if((A1:A4="Jones")+(C1:C4"0"),C1:C4))
Column A represent sales rep column,...
|
|
1 |
74 |
|
|
|
|
5 |
160 |