|
|
Excel cannot auto start external application by
Jason Falzon[_2_]
I have an excel file that with the copy/paste special/link features I managed
to insert a 3d scatter graph in excel using an external application called...
|
|
0 |
152 |
|
|
Collate Worksheets into single workbook by
jw4774
I have a number of a folder containing a number of workbooks each of which
contains a number of worksheets. I am trying to combine just one worksheet
from...
|
March 25th, 2010 09:30 AM
by jw4774
|
3 |
167 |
|
|
Merge contents of two worksheets by
Grey Old Man[_2_]
I am a novice writing an Excel 2002 template. I import external data from
sources A and B into sheets 1 and 2. There are no duplicate rows.
I have named...
|
March 25th, 2010 08:31 AM
by jeya
|
1 |
200 |
|
|
about screenupdating by
baha
Hello,
I have a long code which is a kind of poker simulation that gives you
simple random poker hand and calculates the odds.If I disable
screenupdate some of...
|
March 25th, 2010 07:16 AM
by baha
|
0 |
117 |
|
|
Ctrl+E to center by
Thomas S.
MS Word and PowerPoint has had the "Ctrl+E to center" function for years, and
I am really hoping this will be extended to MS Excel soon. Today, typing the...
|
|
2 |
147 |
|
|
Formula copying error by
KKGV
I've entered a vlookup formula and when I copy it to another cell, sometimes
it copies the formula correctly into the other cells and comes up with the...
|
March 25th, 2010 06:31 AM
by Max
|
3 |
161 |
|
|
look up question by
G
Hi , I have 2 columns - column A containes dates , coumn B contains
activieties ( meetings , phone calls , emails ) ..
I'd like to have a formula that...
|
|
1 |
144 |
|
|
|
|
1 |
160 |
|
|
How to find errors in documents by
Pnoahjones
when you have a series of data and you have a space or error in your numbers
when you are using functions and formulas. how do you find where there error
is...
|
|
1 |
137 |
|
|
Pivot Table Default Setting by
Registrar
Can you change the default setting in Pivot Table? For Example if everytime I
do a pivot table I do not want it to give me subtotals can I default it that...
|
March 25th, 2010 05:14 AM
by Matt S
|
1 |
193 |
|
|
Hide unused rows and columns by
kyleb
In excel 2007 i would like to hide All rows and columns except for the few i
have data entered into. Any advice? Thanks
|
|
1 |
277 |
|
|
Scrolling from a created gridline in Excel by
Roy[_2_]
Hello group
I am not quite familair with some of excels manipulative prowess...
I noticed that its possible to scroll up or down from a
gridline ...say by...
|
|
2 |
185 |
|
|
|
March 25th, 2010 02:13 AM
by Kelstar
|
2 |
189 |
|
|
top ten ranking by
liem
I have 20 category in each category I have random 1 to 500 items with sales
units and Sales $ metric for each items.
How can filter and rank it will show up...
|
March 25th, 2010 02:12 AM
by liem
|
0 |
136 |
|
|
If(AND formula by
Wildwood
Please help......this formula is returning a Value error.......what is wrong?...
|
|
9 |
163 |
|
|
Insert Name Define by
Chris Johnson
Why does this work for a Name definition of a range?
=Sheet1!$A$3:INDEX(DataforCharts!$A:$A,MATCH(9.99999E+307,DataforCharts!$A:$A))
It works but I can't...
|
|
1 |
149 |
|
|
|
March 25th, 2010 12:16 AM
by kyleb
|
1 |
123 |
|
|
include rounding in a formula by
KrispyData
i have the following:
A B C
1 327.2 3033.56 0.107860072
column C1 is simply A1/B1 . Is there a way that i can include in my formula
to round the results...
|
March 25th, 2010 12:01 AM
by kyleb
|
2 |
108 |
|
|
Name scope within a workbook by
Christer
I have 3 different workbooks open. A sheet within one workbook contains a
number of named Ranges. When I copy the sheet into one of the other workbooks
the...
|
|
0 |
99 |
|
|
Find Command by
Mike H.
If I do a "find" (Ctrl-F), I wish to find the value 1500 but the cell that
contains 1500 contains the formula A1*B1 and A1=750 and B1=2. How can I find...
|
March 24th, 2010 11:10 PM
by Mike H.
|
8 |
192 |