|
|
Worksheet in a worksheet? by
Philip Reece-Heal
Is there any way to insert a worksheet in an Excel worksheet, like you can
insert a Word document in an Excel worksheet?
Regards
Philip
|
September 16th, 2005 10:18 PM
by Jim May
|
6 |
107 |
|
|
|
|
1 |
111 |
|
|
|
|
3 |
123 |
|
|
Custom Format for hours and minutes by
Paul D. Simon
Probably not possible, but thought I'd ask anyway...
I altered the h:mm time format to the custom format
h "hrs", m "mins". So, if I type 3:3, the cell...
|
|
4 |
273 |
|
|
|
|
1 |
77 |
|
|
|
|
0 |
72 |
|
|
Sorting Numbers with Multiple Decimals by
Intern Ian
I am attempting to create a file system using excel that can be easily
searched and sorted by a number ie 1.3.12 or alphabetically. At this time I
have...
|
|
4 |
91 |
|
|
Range of Factorial Function by
Rushi
Hi,
For some analysis I am doing, I tried the following LOG(FACT(229)), and it
returned NUM!. I am wondering if 229 is too big a number to compute a
Factorial...
|
|
7 |
122 |
|
|
|
|
2 |
77 |
|
|
using percentages in an if statement by
matt
Is there a way I can incorporate the percentage of values that meet a
critiera into an If statement. For instance, say I've got
1
2
3
4
5
6
7
|
September 17th, 2005 01:42 AM
by Ragdyer
|
2 |
85 |
|
|
Conditional Sorting by
Rob
I am looking to do a descending sort based on two columns being the same.
Here is a simple example of what I want to do
Before Sort
After Sort
Column 1 ...
|
|
1 |
157 |
|
|
|
|
1 |
107 |
|
|
Merge worksheets - exceptions by
tlozier
We run weekly reports that grow from week to week. We are looking for a
method to take last weeks worksheet and merge with the latest worksheet. For
example...
|
|
1 |
98 |
|
|
Merge Worksheets - Exceptions by
tlozier
We run weekly reports that grow from week to week. We are looking for a
method to take last weeks worksheet and merge with the latest worksheet. For
example...
|
|
1 |
108 |
|
|
Please Help!!! With Drop-down List by
seantera
Is there any way to control how the dropdown list is displayed?
Specifically, I have a data validation list in a cell. The column it is
in is only 4 units...
|
September 17th, 2005 02:56 AM
by hideki
|
1 |
75 |
|
|
Hyperlinks stopped working in Excel 2003 by
Pilot
I upgraded from Excel 2000 to Excel 2003, and my new hyperlinks don't work.
I scan all my documents and index them in an Excel spreadsheet. The
hyperlink...
|
September 17th, 2005 06:18 AM
by Pilot
|
3 |
282 |
|
|
VLOOKUP error by
Eintsein_mc2
Hi I keep getting an error when I try and put in the last vlookup into
the...
|
|
2 |
78 |
|
|
finding addresses by
donone
I have tried for several hours and failed.
I want, say, A1 to contain 1.
I want A2 to self generate its value as the cell above +1
etc. etc. but of course NOT...
|
September 17th, 2005 07:45 AM
by donone
|
5 |
92 |
|
|
|
|
2 |
84 |
|
|
Deactivate formula after a set time by
y_not
Is it possible to set formulas to deactivate after a given period of
time?
I email out a number of spreadsheets that have taken many hours/days to
assemble to...
|
|
1 |
104 |