|
|
|
Lists
Mon, 1 Sep 2008 19:10:06 -0700
Hi, I have a problem I need help with. I will attempt to explain what I am
trying to do. I have created a drop down box with several customer's names
to choose from. Each customer has different "unit" numbers to choose from.
What I am wanting to do is when I select a customer, I want the next drop
down l ...
|
Paste Link between Worksheets
Mon, 1 Sep 2008 18:32:01 -0700
Hi, I have been using 2003 and 2007 versions of Excel and trying to link
graphs from one master sheet to another file so that it automatically updates
when i do changes in the master sheet. The Paste link button does not show
whenever I copy the graph and paste it on to another worksheet. Is this a
limitatio ...
|
I need a Line of Credit Calculator
Mon, 1 Sep 2008 18:00:00 -0700
I know this may be a bit of a 'big one' but, I really need a calculator that
will allow me to have a fixed interest rate, and then allow me to enter
payments or withdrawls to determine the current balance of the line of
credit. Anyone up for making such a beast for me? I am just horrendus at
loans and that s ...
|
2007 Conditional Formatting
Mon, 1 Sep 2008 17:07:00 -0700
In older versions of Excel, I used to set 3-4 conditions in cells A1 to A4.
Then, I would copy these 4 cells across to Column BZ and all would be well.
Now, in Excel 2007, it appears weeks later, that my 4 conditions multiply
into hundreds (if not thousands) of conditions! This bogs down my
spreadsheet im ...
|
Excel Cell Reference
Mon, 1 Sep 2008 15:24:00 -0700
I am trying Office 2007 and in Excel I have at one attempt tried to reference
a cell in another sheet in the same workbook and another time have attempted
to reference a cell from another workbook. In both cases it only shows the
formula of the typed in reference, such as =Sheet5!A$1$ and the other was
sho ...
|
Finding the solution to an Exel problem.
Mon, 1 Sep 2008 13:38:01 -0700
My scenario is as follows: I have 2 adjacent cells that have 'VLOOKUP'
functions and they return a value when certain criteria are met. There are
only 4 value scenarios that can occur. 1) Both cells have no response and a
'#N/A' is displayed in each cell. 2) Both cells have the same response,
(ie:'XT25' & ...
|
Excel Round
Mon, 1 Sep 2008 12:00:00 -0700
Hi: I need to round a formula from a decimal to a percent here is the
foemula,=VLOOKUP(D10,Customers,9)&"/"&VLOOKUP(D10,Customers,10,FALSE)&"
"&VLOOKUP(D10,Customers,11,FALSE)&" "&VLOOKUP(D10,Customers,12,FALSE) I need
to put the percent in the first vlookup it is now showing as a decimal but I
want to roun ...
|
|
|
Calculating Information
Mon, 1 Sep 2008 11:26:00 -0700
I have created a workflow to determine work hours from when a request was
received until it is completed. The date / time is captured as yyyy/mm/dd
hh:mm
In the workflow the date / time is captured in column A while the type off
request (open account) is captured in column F.
I am now creating a summary ...
|
Sum values in one row dependent on a value in a different row
Mon, 1 Sep 2008 10:27:01 -0700
In Row 5 I have 9 cells with the text value of S, W or R, 3 of each - ie S,
R, S, W, W, S, R, R, W. This is a random order that changes in each table.
In Row 9 there is a different numerical value in each Cell. I want to sum
the cell values in Row 9 that correspond to the 3 columns that have the S,
the R ...
|
How do I omit a blank cell from a calculation??
Mon, 1 Sep 2008 10:08:10 -0700
How do I discriminate between a blank cell and a zero value cell in a formula? ...
|
|
|
