Another Error Cont'

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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"
 
Back
Top