View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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