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 ...
|
|
|
an Excel file can't be saved
Tue, 26 Aug 2008 22:06:15 +0800
hi, buddy. I have a excel file which include macro. this excel can't be
saved when I change the content of this excel file.
and I disabled the macro of this file. and this problem still exists.
But his other excel file haven't this problem
So I reinstall his office, but this problem also can be solved.
How ca ...
|
Macro: Closing files without saving
Tue, 26 Aug 2008 05:54:50 -0700 (PDT)
Hey guys
I'm trying to pull together data from several workbooks.
To do this I have to modify every submitting workbook (show hidden
columns etc). There are apx 100 subsequent submitting files to open,
processing and close
In the macro I open the files as "read only" to prevent unwanted
actions.
My problem ...
|
Excel opening old version of file
Tue, 26 Aug 2008 04:54:00 -0700
I have an excel attachment sent from a colleague via outlook 2003 email. The
attachment sent from my colleague is version 12.
The attachment opens on my pc as a previous version. It is version 11.
When I forward the attachment to another colleague the attachment is version
12 as it should be.
The p ...
|