| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
