|
|
Multiple criteria by
Solar Man
Hi, I'm trying to find the formula for entering a value in a cell based on
multiple criteria.
I'm working on a solar heating sheet.
I have a drop down menu...
|
|
7 |
106 |
|
|
Webquery by
Neale
I am attempting to get data from an internal webpage. When I do I get the
following message: "The page you have requested requires JavaScript to
function...
|
August 25th, 2008 05:26 PM
by Neale
|
3 |
72 |
|
|
Format Cell contents as MM by
Sandy
Hello
I have a monthly file My File mm-yyyy.xls. I am trying to reference last
months file using cell C1 (Named month) and indirect.ext using...
|
|
4 |
90 |
|
|
Sum by
Sum problem
I would like to sum a common cell, by defined name, accross a set of
different sheet. The cell name is the same, with a scope to the sheet only.
...
( 1 2)
|
August 25th, 2008 04:39 PM
by Spiky
|
10 |
191 |
|
|
MAtch drop down list selection to data sheet by
SMOKN_ENG_MOM[_2_]
I am trying to match a selected item from a drop down list (sheet 1) to a
column on another sheet(2) and return information from another column on
sheet 2 to...
|
August 25th, 2008 04:16 PM
by Gav123
|
1 |
125 |
|
|
//autoaverage. by
sansk_23
Hi !! If i have a table like below :
WEEKS EAST NORTH SOUTH...
|
|
2 |
121 |
|
|
|
|
1 |
316 |
|
|
|
August 25th, 2008 03:53 PM
by Spiky
|
4 |
206 |
|
|
payback period for a 10 years investment by
tlgoh
I need help to set up a table to calculate a payback period of an investment
of $1.0 Million. what are the parameters and assumptions I need to consider
|
|
1 |
100 |
|
|
//pivot - unique records . by
sansk_23
Hi !! I have a table like this :
Location Order Invoice Week
A 1 X1 20
A 1 Y1 20
B 2 X2 ...
|
|
3 |
115 |
|
|
excel 2007 pivot table wizard by
CIL
Good Afternoon.
Thanks in advance for your help.
I am being forced to go to 2007 since the work environment has updated their
software packages and I am...
|
August 25th, 2008 03:27 PM
by CIL
|
2 |
213 |
|
|
Start, Finish including break time by
Ricardo
Hi all,
I currently have a excel spreadsheet set up to take the following.
Just an example:
Cell A1 - Time Started (In 24 hour time) - "06:30"
Cell A2 - Break...
|
|
2 |
117 |
|
|
|
|
1 |
135 |
|
|
Help with changing a formula by
JBoyer
The current formula I have is...
=IF(COUNTBLANK(INDEX(F:L,ROW(),))COUNTBLANK(INDEX(F:L,ROW()+1,)),"PENDING
CREDITS","")
I want to make one addition to this...
|
August 25th, 2008 12:16 PM
by JBoyer
|
4 |
138 |
|
|
auto step sum by
confused deejay
hiya
i am writing a spred sheet where if i select a drop down list then enter a
sum the sum would be inserted into then appropriate cell. my problem is i...
|
|
3 |
101 |
|
|
formula help by
RayB
I'm a novice Excel user. This is probably basic, but.. whats the proper
formula for this activity?
row 3 - column c is a number - 20 column d is a number...
|
|
3 |
96 |
|
|
|
|
5 |
132 |
|
|
Worksheet Functions by
Steve Peel
My simple formula referencing the value of another cell is written over by
that value when the value of the referenced cell is changed? This is a
strange...
( 1 2)
|
August 25th, 2008 05:06 AM
by Max
|
12 |
201 |
|
|
|
|
10 |
173 |
|
|
Question on create chart by
Blue Fish[_2_]
Hello:
I would like to have summary of the existing OS in % ratio with Pie
Chart present. May I know how can I create in base on the existing data?
Attached...
|
|
0 |
99 |