Thread
:
Another Error Cont'
View Single Post
#
5
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett