|
NPV
Anyone know how I can do an NPV calculation with more than 29 values? Many
of the adjacent values are identical and there will be no more than 29
different numerical values, however, using ranges doesn't seem to help.
Also, is there an instruction book which goes into solid detail on the
financial or other functions? Excel help is too elementary for many aspects.
Thanks.
--
hm...
|
7 |
26.09.2006 23:26:02 |
|
|
Formula to count cells that contain a number & are not shaded
Hello,
I am trying to get Excel to count up blank (or non-shaded) cells, as well as
cells that contain a "1" in it. Can someone please suggest a formula to do
that? I really need it & an excel "guru" told me it could be done, but he
didn't remember how. Any help would be greatly appreciated.
Thank you!...
|
3 |
26.09.2006 22:52:34 |
|
|
How easy is it to change the server odbc details for excel
Hi Everyone
I have a slight problem and wondered if anyone had seen anything similar.
We had to change the network IP address of the server that people connect to
with odbc in excel. How easy is it to change the excel details. At present I
have to wait until it times out before I can alter the details.
Is there an easier way?
Thanks
Bryan...
|
1 |
26.09.2006 22:45:01 |
|
|
COPY
I would like extract the entire row of information from the received excel
spreadsheet into the non-compliance excel spreadsheet that meets the criteria
of "OLD", "0" "XL", "XC", "XR" or "VAC". There are five columns that could
contain this information. Please note that it is possible for none or many
of these entries to be in each row. I've unsuccessfully tried several things
that di...
|
2 |
26.09.2006 22:38:18 |
|
|
[VBA] Hiding rows in PivotTable
Hi,
I have PivotTable in Excel 2003. In "Row Fields" there is dimension called
[DepartmentEmployee] which consists of [Department] and [Employee] levels.
To hide rows I used the following code:
Sub Hide()
Dim pt As PivotTable
Dim pf As PivotField
Dim pi As PivotItem
Set pt = ActiveSheet.PivotTables(1)
Application.ScreenUpdating = False
Applicat...
|
2 |
26.09.2006 22:18:30 |
|
|
Formatting from Number to Text
I have an excel file that has one column for Product No (alphanumeric). I
have found that some of the cell are displaying Scientific Notation (e.g.
4.00000e+016) even when I specified the formatting to be text. The only way
I could get them to show as 40000001235 is to go to each cell and click on
the formula bar. Is there an easier way? I've tried =Value(abc123),
=abc123, copy and p...
|
4 |
26.09.2006 22:15:03 |
|
|
Excel 03 typing problem
When I type a forward slash( / ), it won't type, but it highlights the "File"
heading....
|
2 |
26.09.2006 21:46:14 |
|
|
I'm trying to determine how a series of dropdown lists were creat.
I'm trying to determine how a series of dropdown lists were created in an
existing Excel worksheet that I'm editing. Row 1, Columns A through G have
dropdowns with extensive lists in each. If I click on Row 1 itself I see the
apparent name of the Row, "Print_Titles". But I cannot determine how the
lists were created and where they reside. This is the only worksheet in the
workbook.
...
|
3 |
26.09.2006 21:39:22 |
|
|
Headers and Footers...oh my!
I have a workbook that contains anywhere from 10 tabs to 70 tabs - I am
trying to update my header to reflect 4th Quarter dates - I grouped all
worksheets together and then went into my set-up, but when I make the update;
save; ungroup all worksheets...it's only changed the worksheet I was on, not
the entire group. What am I doing wrong? I have about 100 workbooks that I
have to update -...
|
2 |
26.09.2006 21:24:38 |
|
|
comments
Hi,
I have a sheet with comments in excel that i want to make available to a
group of users however, i do not want them to see these comments nor do i
want to have to maintain two versions of this document by having to remove
the comments every time i'm ready to make it available to this audience. If i
hide the comments anyone can come into the document and unhide the comments?
is the...
|
1 |
26.09.2006 21:21:05 |
|
|
Excel 2003 Workbook into Word 2003
If I go into Word, and choose Insert/Object/Create From File, Browse, and
find my existing Excel Workbook, only the first Worksheet is inserted into my
Word document.
If I go into Word, and choose Insert/File, and find my Excel Workbook, I get
pages of garbage.
Are both of these behaviours normal for Excel and Word 2003? Is there any
way I can insert a Workbook (with multiple Worksh...
|
5 |
26.09.2006 20:52:01 |
|
|
ADD TO COLUMN (inventory)
I have a column of inventory numbers and I have to dated total columns. In
the two dated columns I am using a (VLOOKUP) combination formula. The table
array is on another sheet with weekly totals. My question is I want to have
the inventory column on my comparison sheet to add any new inventory numbers
from week to week.
note: Preferably I would like to do this when I update my (VLOOKU...
|
1 |
26.09.2006 20:46:02 |
|
|
borders
When I use the double-underline or any of the other underline features in
"Borders", the result is a light colored gray that is hard to see when
printed out. How do I darken this?...
|
2 |
26.09.2006 20:31:01 |
|
|
How to find data character width in Excel
In Excel, is there a way to find out the character width of the data in a
column?
I have a column with 60,000 records and each record contains Street names. I
want to know what is the longest possible street name. I also want to look at
the distribution of the character or pixel width of all the street names.
Similarly, I have about 100 other columns with 60,000 records which contain
va...
|
3 |
26.09.2006 20:27:55 |
|
|
Create tabs named after a group of cells?
Is it possible to create multiple tabs each being named after a particular
cell.
For example:
a1 Apple
a2 Pear
a3 Grape
a4 Banana
Could I somehow select that group of cells and have tabs automatically
generated named, Apple, Pear, Grape, and Banana?
I have a rather large list and would like to automate the process if possible.
Thanks in advance!...
|
4 |
26.09.2006 20:21:01 |
|
|
Name of Text-Box Right-Click Command Bar?
The following macro inserts two new selections to the menu which appears when
you right-click on a worksheet:
Sub Add_Controls()
Dim i As Long
Dim onaction_names As Variant
Dim caption_names As Variant
onaction_names = Array("InputMacro", "RegroupObjects")
caption_names = Array("WORKDAY Edit", "Restore Project Info Boxes")
With Application.CommandBars("Cell")
...
|
2 |
26.09.2006 20:07:42 |
|
|
width and height use diferent unit, what units are those?
Why
width units relation is 3 units/26 pixels
and
height is 3 units/4 pixels,
what kind of units use each one?,
how can I use a real scale in the work sheet?...
|
3 |
26.09.2006 19:56:28 |
|
|
One workbook to another . . .
I'm not looking for volumes of info on this one. (Um, that doesn't mean I
wouldn't appreciate it, though! LOL) I just need a jump start so I can
figure out what to do to get started.
I have a workbook with about 50 sheets. 4 of the sheets get data, dumped
from a program. That data is carried to other sheets as needed.
These "other" sheets basically just have a formula in each cell...
|
3 |
26.09.2006 19:49:04 |
|
|
SUM function???
This is a new one.
Using the SUM function in XL 2003 to sum up a series of cells:
=SUM(G10+G16+G37+G52+G127+G156+G178)
All of these cells have values in them, which are themselves sums of other
ranges. All cells in this formula are themselves calculating correctly,
however, this formula is resolving to 0 (all calculations in the cells above
are positive, so 0 is mathematically impos...
|
6 |
26.09.2006 19:43:13 |
|
|
hours and minutes
If I have a spreadsheet that in column A= seconds. I want to take the
seconds in col a and in column b make minutes, then in column c, the minutes
to make hours, and then in column d, the hours to make days. I do not know
how to divide to get the correct answer in each of the columns....
|
6 |
26.09.2006 19:43:02 |
|
|
Get File location
Hi,
I want to run a macro and then be able to choose files on my computer, then
save the chosen file location as a variable. Is there anyway to do this?
Sub Macro()
Prompt: Choose filename
Variable = Filename
End sub
Thanks for your help!
...
|
3 |
26.09.2006 19:20:58 |
|
|
Filter causes file to recalculate
I have a file with a lot of calculations and everytime I change the filter
criteria it recalculates. This is driving me crazy. I've changed the
subtotal calculations to sums. Is there anything else that would cause it to
recalculate when the filter is changed?...
|
5 |
26.09.2006 19:16:25 |
|
|
Forcing Text
I've got an Excel template that users enter data into. We have Customer ID's
with leading zeros, but Excel cuts them off and treats them as numeric
values. Is there any way I can define a column as text so the user can enter
0000456 without having to key a ' before the entry?
I've tried defining the column using Data => Text to Columns => Text, but
that isn't working....
|
3 |
26.09.2006 18:57:16 |
|
|
HOW DO I CHANGE THE FONT SIZE FOR A RANGE NAME?
When operating in excel and setting up range names; is there any way to
reduce the font size for the range names?...
|
2 |
26.09.2006 18:41:02 |
|
|
file size & error checking
Does anyone know if turning off error checking will make file sizes smaller?
I have a spreadsheet that keeps growing is size, but only a row or two has
been added. There are a ton of the green triangles in it though....
|
4 |
26.09.2006 18:40:51 |