|
|
Launching Excel opens multiple workbooks by
Herb
This is particularly apparent when you double click an
icon to open an existing workbook.
Example:
I have a workbook named "Original Carrier List.xls"
When it...
|
June 16th, 2004 05:35 AM
by
|
2 |
373 |
|
|
|
|
1 |
257 |
|
|
SUM IF multiple criteria by
kennis
I have figured out how to do SUMIF (A1:A8, "9", B1:B8) in order to calculate all the B values corresponding to anything greater than 9 in the A column. I am...
|
|
5 |
213 |
|
|
|
June 16th, 2004 04:03 AM
by Biff
|
1 |
167 |
|
|
palindromes by
thank you
Looking for palindromes solution.
Something that would print number of steps and the end result when a number entered in cell A1.
Thank you!
|
|
1 |
193 |
|
|
Calcuating % of increase - negative amts by
Mark
I am trying to calculate the % of increase in revenue
from one year to the next.
If Cell A2 (2003) is $100.00
If Cell A3 (2004)is $500.00
% of Increase in...
|
|
5 |
421 |
|
|
Excel Manual Calculation is stubborn by
Hari
Hi,
I set my Excel options -- calculation to manual because I have one very
heavy sheet.Last 3 weeks or so I didnt change the option.
Now, I want to change...
|
|
7 |
634 |
|
|
Copy & Paste sections of data by
Christine Wilso
I receive data each day exported into an excel file. In column A there
is a list of Areas, in column B a list of months from April to whatever
the month we are...
|
|
1 |
326 |
|
|
TextToColumns question by
Arch
I want to split full name column into three columns, first, middle, last. Some of my full names do not have middle initials. In that scenario, the last name...
|
|
2 |
192 |
|
|
Custom Fill Colors Issues by
G. Sesame
Hello.
I have saved three custom colors in my fill color box. Whenever I send a file containing these custom colors to another user, the user doesn't see the...
|
|
3 |
549 |
|
|
Calendar Mail Merge?? by
JMax
Good Afternoon,
I have a fairly simple spreadsheet with less than 10 columns. Each
item (row) contains 3 dates, Open Date , Close Date and Live Event.
Is it...
|
|
1 |
343 |
|
|
choosing from drop down lists easily by
Dave W
I have several lists that appear as a result of
selections from other list through data validation.
Is there a way to go right to say ..all the words...
|
|
1 |
302 |
|
|
create datevalue yyywwd by
jocke
is there any way to create the datevalue yyyywwd (year, weeknr, day of
week) from today's date? in vba code or/and in a spreadsheet
tia
/jocke
---
Message...
|
|
2 |
337 |
|
|
|
|
1 |
399 |
|
|
email attachment by
rgm
I have been sent email attachment with .xls extension. I
do not have excell on my computer. Is there a way to open
the attachment? Thanks for your help.
|
|
1 |
270 |
|
|
Macro needed? by
Continental Translations
I am after something which will delete excess spaces in certain cells. In
some of my cells, I have a couple of words. Some of these words however have
2 spaces...
|
|
8 |
329 |
|
|
Hiding Checkbox from "Forms" Toolbar by
bg18461
I have some rows that I want to hide in my spreadsheet, I also have
checboxes within those rows to hide. When I hide the rows, the
checkboxes remain. I know...
|
|
6 |
561 |
|
|
Adding the DAY to a Date field? by
Earl Kiosterud
Dave,
I couldn't get the Alt-0010 to work. It drops to a second line in the
custom format box as you would expect (I have to arrow up and down -- it
only...
|
|
3 |
268 |
|
|
Drop downs by
Neil R
I have an excel worksheet which contains 3 seperate worksheets into one. I have managed to use the drop down function on the main worksheet from data used on...
|
|
2 |
518 |
|
|
Row Hidden or height set to 0 by
CS
The A1 row in my worksheet is not visible and I can't find
a way to display it. Following help, I went to Edit/Go
To/"A1" then Format/Row/Unhide or Height = 13...
|
June 15th, 2004 11:44 PM
by CS
|
7 |
334 |