I am stumped!

[Ken Wright]

LOL - sorry Harlan, shouldn't have been so lazy.

As stated - Two dialog boxes with seq values


A1:F10000 misc values of 1- 6
G1G10000 =rand()

looping 10,000 times in each case.

Scenario1
L1 = COUNTA(A:A)

J1
=SUMPRODUCT(--(OFFSET($A$1,,,L1,1)=1),--(OFFSET($B$1,,,L1,1)=2),--(OFFSET($C
$1,,,L1,1)=3),--(OFFSET($D$1,,,L1,1)=4),--(OFFSET($E$1,,,L1,1)=5),--(OFFSET(
$F$1,,,L1,1)=6),OFFSET($F$1,,,L1,1))

Scenario2
J1
=SUMPRODUCT(--(OFFSET($A$1,,,COUNTA(A:A),1)=1),--(OFFSET($B$1,,,COUNTA(A:A),
1)=2),--(OFFSET($C$1,,,COUNTA(A:A),1)=3),--(OFFSET($D$1,,,COUNTA(A:A),1)=4),
--(OFFSET($E$1,,,COUNTA(A:A),1)=5),--(OFFSET($F$1,,,COUNTA(A:A),1)=6),OFFSET
($F$1,,,COUNTA(A:A),1))

Scenario3
rng defined as =COUNTA($A:$A)

J1
=SUMPRODUCT(--(OFFSET($A$1,,,rng,1)=1),--(OFFSET($B$1,,,rng,1)=2),--(OFFSET(
$C$1,,,rng,1)=3),--(OFFSET($D$1,,,rng,1)=4),--(OFFSET($E$1,,,rng,1)=5),--(OF
FSET($F$1,,,rng,1)=6),OFFSET($F$1,,,rng,1))

Each run twice to ensure consistent values - times to run:-

S1 = 04:19
S2 = 04:40
S3 = 04:40

 

[Ken Wright]

looping 10,000 times in each case.

and calcing each time obviously

 

[Max]

Noticed that you have requested for your post/all threads?? *not* to be
archived in Google (Re: the header in your original post in Google - message
will be removed on Feb 18, 10:49 pm??). Just thought it'll be quite a loss
for the community's future reference to have this event occur in view of the
many posts / insights by the many who have since added-on so much value to
the subject/discussions. Any chance that you could reconsider your
request?? Gotta act quickly, time's running out ..

 

[Harlan Grove]

Max wrote...

Noticed that you have requested for your post/all threads?? *not* to be
archived in Google (Re: the header in your original post in Google - message
will be removed on Feb 18, 10:49 pm??). Just thought it'll be quite a loss
for the community's future reference to have this event occur in view of the
many posts / insights by the many who have since added-on so much value to
the subject/discussions. Any chance that you could reconsider your
request?? Gotta act quickly, time's running out ..

Do you understand how the Google Groups archive works? Do you
understand how optional tags in newsgroup messages work? Just because
the OP's message goes bye-bye in 3 days doesn't mean all the responses
do too.

The OP's message includes an X-No-Archive tag set to yes. To the extent
I've checked, none of the responses aside from the OP's follow-ups
include this tag. Therefore, the responses will remain even if the OP's
original message and follow-ups are purged.

Now, since so few (so darned few) respondents in these newsgroups
either know how to snip quoted material from previous posts or that
they should snip all but the most relevant preceding bits, there are
several FULL copies of the OP's original message and follow-ups in the
other responses.

HOW MANY COPIES OF THE OP'S ORIGINAL MESSAGE AND FOLLOW-UPS DO YOU
NEED?!

[And how would you expect the OP could alter the X-No-Archive tag in an
already posted newsgroup article?]

 

[Max]

Thanks for the in-depth explanations, Harlan !
It met the call ..

 

[Sandy Mann]

Now, since so
few (so darned few) respondents in these newsgroups

either know how to snip quoted material from previous posts or that
they should snip all but the most relevant preceding bits, there are
several FULL copies of the OP's original message and follow-ups in the
other responses.

At last! Now I feel like I have been of some use around here! <g>

Sandy