Another Error Cont'

[DavidB]

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

 

[Don Guillett]

pls stay in the ORIGINAL thread

 

[Max]

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.

 

[DavidB]

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

 

[Don Guillett]

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"

 

[DavidB]

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

 

[Max]

You are welcome, DavidB !