|
|
|
File won't open!
Wed, 27 Aug 2008 12:33:58 +0100
Hello.
I close an excel file, and then when I go to open it again, nothing. Gone.
From within Excel just a slight movement of the mouse, then nothing.
Nor double clicking the file from it's location, Excel opens, but there's no
file, not even a blank new one. And there is no message whatsoever.
Thank GOODNES ...
|
Changing Case in a Cell
Wed, 27 Aug 2008 02:36:51 -0700
Is there a way to type the word "yes" in to a cell and have it change
to "YES" uppercase? Without the quotes of course.
Thanks ...
|
Reevaluate formula/function in cell
Wed, 27 Aug 2008 02:25:37 -0700 (PDT)
Hello,
Is there a way to redo all calculations in a worksheet in Excel 2007?
The worksheet I have has a small VBA function which gets the
filelength of some files on my machine:
Function Length(location As String)
Length = FileLen(location)
End Function
Some of the files get updated, so I wish to ...
|
Excel 2007 data missing from screen
Tue, 26 Aug 2008 23:43:01 -0700
Hi, The problem I am experiencing with Excel 2007 is when scrolling up or
down with either a portion of text highlighted; a cell selected to be copied;
or copying a cell by dragging down a column, data just disappears from the
display. The data is still there, the screen just no longer shows it. To make
it a ...
|
compute percentiles from Z-scores
Tue, 26 Aug 2008 22:41:07 -0700 (PDT)
Dear all,
Has anyone a macro/syntax or a formula I could use to calculate
percentiles & percentile ranks from Z-scores?
Thanks ...
|
I want to number a long column like A1 - A500 consecutively
Tue, 26 Aug 2008 15:48:06 -0700 (PDT)
So that each number is the preceding number plus one. It is for a long
list of auction items and this will iterate the lot numbers (1-500 in
this case). (there will actually be 10,000, so I don't want to type in
each one.
I already found a macro that will create a specified number of rows,
if that helps.
T ...
|
Selecting a Range
Tue, 26 Aug 2008 15:42:19 -0700
=IF(ISERROR(AVERAGE(O17:O2013)),0,(AVERAGE(O17:O2002)))
I have this formula in a cell but I want to add a condition. I want
it to average the data in question but only if:
c17:c2000="sar"
Whats the easiest way to insert that in there? ...
|
|
|
XIRR with more than two columns
Tue, 26 Aug 2008 14:24:11 -0700 (PDT)
Hi,
I'm trying to use Excel to keep track of the running internal rate of
return (IRR) for a stock portfolio. I have my spreadsheet set up
something like this:
Date | Cash In | Current Value | IRR
1/1/04 | 100 | 100 | 0 %
1/1/05 | 200 ...
|
Sort numbers alphabetically
Tue, 26 Aug 2008 14:19:10 -0700 (PDT)
Let's say I have a list:
1
2
5
20
35
I want it alphabetical, ie:
1
2
20
35
5
Even if I make them text, they still sort numerically.
Is there some trick?
Thanks, Joe ...
|
Column names??
Tue, 26 Aug 2008 08:22:00 -0700 (PDT)
Hi
My Column names are not showing-up as A, B, C, D...
They are showing-up as 1, 2, 3, 4, 5...
I do not understand why this is happening??
I have tried running: Excel.exe /regserver
Any suggestions??
Thanks
Clive ...
|
|
|
