|
|
hlookup to propigate validation table by
Gord Dibben
For creating dependent lists with Data Validation see Debra Dalgleish's site.
http://www.contextures.on.ca/xlDataVal02.html
Gord Dibben XL2002
On Mon, 10...
|
|
1 |
372 |
|
|
Calculating new dates by
Chip Pearson
Talitha,
You can add days to a date by simply adding that number to the date. For
example,
=A1+90
will add 90 days to the date in cell A1. If you want to...
|
November 10th, 2003 10:52 AM
by
|
1 |
193 |
|
|
Summing multiple categories - Help!!! by
Andy Brown
You could try a Pivot Table (Data menu).
Step1 ; Data = Excel list, Report = Pivot Tbale. Click Next.
Step 2 ; select your data on the sheet. Click...
|
November 10th, 2003 01:06 PM
by James D
|
6 |
283 |
|
|
Use date document created in formula? by
jamieuk
We have a template that requires the user to enter the date they
started using the workbook. This date is used in many formulas within
the template.
Rather...
|
|
3 |
301 |
|
|
|
November 10th, 2003 03:45 PM
by GB
|
1 |
425 |
|
|
External References by
Pinda
When one has external references in a workbook, a dialogue
box pops up on opening the workbook saying...
"The workbook you opened contains automatic links...
|
November 10th, 2003 03:52 PM
by Pinda
|
2 |
133 |
|
|
Array Function - cell to remain blank by
mare
I am a novice on Excel, however, I don't get easy projects.
I have a spreadsheet where D6:D15 have values. In cell D17
is the Total, which is an average of...
|
November 10th, 2003 04:09 PM
by immanuel
|
1 |
92 |
|
|
|
|
3 |
410 |
|
|
Assign a multiple commands by
Steve Adler
Hi ;
Is it possible to assign multiple commands to an excel
button.
If so , i'd like to create a custom button to paste the
copied data as values .
Normally...
|
|
4 |
242 |
|
|
Change sign of entire column of numbers by
mure
Just enter in one cell "-1" , "copy" this celle, then you
select your column and make a "special paste" and
click "multiply" : this will multiply your column...
|
November 10th, 2003 04:34 PM
by mure
|
0 |
460 |
|
|
|
|
2 |
506 |
|
|
|
November 10th, 2003 04:53 PM
by Max
|
0 |
478 |
|
|
Compounding by
Mike
I would like to know how to compound cash flows now.
How do I take a series of cash flows and reinvest them at
a continuous factor. let us say 10%.
If I have...
|
|
4 |
88 |
|
|
RANGE NAMES by
BOB F
How can I printout a list of all the range names and cell references used in a workbook?
|
November 10th, 2003 05:36 PM
by MS
|
1 |
237 |
|
|
Finding Last Contiguous Column Cell Entry by
GBL
Hi:
Sorry!! I lost the answered response to this problem (posted about a
week ago), so must re-post it again.
I have a column (A1:A100) that is only partially...
|
|
3 |
197 |
|
|
Locking formulas in cells by
Zeina Dahdouh
Hello,
I have a problem with locking a formula in a cell. For
example: A1 and B1 contain numbers and C1
contains: "=A1*B2".
I want to lock it so i make the...
|
|
1 |
360 |
|
|
Paste Less Decimal Places by
Niek Otten
You could ToolsOptionsCalculationPrecision as diplayed, but read Help to
be aware of the implications
--
Kind Regards,
Niek Otten
Microsoft MVP -...
|
|
2 |
511 |
|
|
|
|
13 |
924 |
|
|
DATE by
Geneva Sachs
Sorry! I'm new at this and tried to send the sample of
what I'm working on. This is the formula I've got...
|
|
4 |
151 |
|
|
Creating a Custom Excel Formula by
Beth
Is it possible to create a formula in Excel which will
identify a value within a range of cells and create a
text base response if that value is located.
For...
|
|
3 |
234 |