Another Error Cont'
 

Max, Followed directions but H8 is still only displaying Undefined...I am
stumped!
Is it possible you could have a look at the spreadsheet and tell me where
I'm going wrong?
Cheers
David

Another Error Cont'
 

pls stay in the ORIGINAL thread

--
Don Guillett
SalesAid Software

"DavidB" wrote in message
...
Max, Followed directions but H8 is still only displaying Undefined...I am
stumped!
Is it possible you could have a look at the spreadsheet and tell me where
I'm going wrong?
Cheers
David

Another Error Cont'
 

David,

As Don responded, you should stay within your original thread

For your easy reference, I've put together a working sample at:
http://cjoint.com/?lpcy4u848V
DavidB_newusers.xls

The sample contains the revised suggestion to your original posting to use a
helper sheet (Y) to group together the discontiguous source range (in X)
into a continuous range. The formula in H8 (in X) then points to the
continuous range in Y for the appropriate evaluations. Full construct
details are provided in the sample file.

Take a look at the sample, and test out the returns in H8 using various sets
of inputs in the 11 source cells.

P/s: I don't know of any other way to get it up here.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DavidB" wrote in message
...
Max, Followed directions but H8 is still only displaying Undefined...I am
stumped!
Is it possible you could have a look at the spreadsheet and tell me where
I'm going wrong?
Cheers
David

Another Error Cont'
 

Thanks Max for all the help. It works well...Oh! by the way whats a thread?

"Max" wrote:

David,

As Don responded, you should stay within your original thread

For your easy reference, I've put together a working sample at:
http://cjoint.com/?lpcy4u848V
DavidB_newusers.xls

The sample contains the revised suggestion to your original posting to use a
helper sheet (Y) to group together the discontiguous source range (in X)
into a continuous range. The formula in H8 (in X) then points to the
continuous range in Y for the appropriate evaluations. Full construct
details are provided in the sample file.

Take a look at the sample, and test out the returns in H8 using various sets
of inputs in the 11 source cells.

P/s: I don't know of any other way to get it up here.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DavidB" wrote in message
...
Max, Followed directions but H8 is still only displaying Undefined...I am
stumped!
Is it possible you could have a look at the spreadsheet and tell me where
I'm going wrong?
Cheers
David

Another Error Cont'
 

What is meant is to REPLY to the original message instead of writing a new
message which may not relate to anything unless you see the original. That
is a "thread"

--
Don Guillett
SalesAid Software

"DavidB" wrote in message
...
Thanks Max for all the help. It works well...Oh! by the way whats a
thread?

"Max" wrote:

David,

As Don responded, you should stay within your original thread

For your easy reference, I've put together a working sample at:
http://cjoint.com/?lpcy4u848V
DavidB_newusers.xls

The sample contains the revised suggestion to your original posting to
use a
helper sheet (Y) to group together the discontiguous source range (in X)
into a continuous range. The formula in H8 (in X) then points to the
continuous range in Y for the appropriate evaluations. Full construct
details are provided in the sample file.

Take a look at the sample, and test out the returns in H8 using various
sets
of inputs in the 11 source cells.

P/s: I don't know of any other way to get it up here.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DavidB" wrote in message
...
Max, Followed directions but H8 is still only displaying Undefined...I
am
stumped!
Is it possible you could have a look at the spreadsheet and tell me
where
I'm going wrong?
Cheers
David

Another Error Cont'
 

Oh! ok...thanks Don.....and once again thanks Max

"Don Guillett" wrote:

What is meant is to REPLY to the original message instead of writing a new
message which may not relate to anything unless you see the original. That
is a "thread"

--
Don Guillett
SalesAid Software

"DavidB" wrote in message
...
Thanks Max for all the help. It works well...Oh! by the way whats a
thread?

"Max" wrote:

David,

As Don responded, you should stay within your original thread

For your easy reference, I've put together a working sample at:
http://cjoint.com/?lpcy4u848V
DavidB_newusers.xls

The sample contains the revised suggestion to your original posting to
use a
helper sheet (Y) to group together the discontiguous source range (in X)
into a continuous range. The formula in H8 (in X) then points to the
continuous range in Y for the appropriate evaluations. Full construct
details are provided in the sample file.

Take a look at the sample, and test out the returns in H8 using various
sets
of inputs in the 11 source cells.

P/s: I don't know of any other way to get it up here.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DavidB" wrote in message
...
Max, Followed directions but H8 is still only displaying Undefined...I
am
stumped!
Is it possible you could have a look at the spreadsheet and tell me
where
I'm going wrong?
Cheers
David

Another Error Cont'
 

You are welcome, DavidB !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DavidB" wrote in message
...
Oh! ok...thanks Don.....and once again thanks Max