|
|
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 |
375 |
|
|
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 09: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 12: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 |
307 |
|
|
|
November 10th, 2003 02:45 PM
by GB
|
1 |
432 |
|
|
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 02: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 03:09 PM
by immanuel
|
1 |
92 |
|
|
|
|
3 |
419 |
|
|
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 |
247 |
|
|
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 03:34 PM
by mure
|
0 |
468 |
|
|
|
|
2 |
524 |
|
|
|
November 10th, 2003 03:53 PM
by Max
|
0 |
489 |
|
|
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 04:36 PM
by MS
|
1 |
242 |
|
|
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 |
202 |
|
|
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 |
365 |
|
|
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 |
519 |
|
|
|
|
13 |
977 |
|
|
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 |
239 |