xldynamic is back

[Bob Phillips]

I forgot to mention that the xldynamic site is back up, I have resolved my
host provider.

I still have to fix the downloads, but eveything else should be working.


Bob

 

[Niek Otten]

That's great Bob, I used to refer to your site quite often but had to stop
doing that.
I'll put the links back in my "list of tips"

 

[Mike H]

Excellent, I directed someone to your count conditional format colours the
other day only to find the site was down

 

[Billy Liddel]

Great news Bob,

i directed someone there the other day for your dependant dropdowns and he
could not download the file. fortunately I was able to send him a copy.

Peter

 

[Ron de Bruin]

Hi Bob

Good, I removed the counter in the hyperlink of the QDE add-in on my site last week so the link was working again

When you have it ready I will change it again.

 

[Pete_UK]

Good news, Bob - glad to hear it.

Pete

 

[Bob Phillips]

I'll let you know when it works again Ron.

 

[Madiya]

I'll let you know when it works again Ron.

--
__________________________________
HTH

Bob








- Show quoted text -

Bob,
I have tried to open ADO/ADOX link which results in 404 - File or
directory not found.
I tried other links also on the same but same error appears.
Kindly fix this also.

Regards,
Madiya

 

[Bob Phillips]

That is what we are referring to.

--
__________________________________
HTH

Bob

I'll let you know when it works again Ron.

--
__________________________________
HTH

Bob

message






- Show quoted text -

Bob,
I have tried to open ADO/ADOX link which results in 404 - File or
directory not found.
I tried other links also on the same but same error appears.
Kindly fix this also.

Regards,
Madiya

 

[Bernd P]

Hello Bob,

My email to your webmaster account bounced back.

I suggested to change your explanation / example for SUNPORODUCT for
an OR condition to change from

=SUMPRODUCT((A1:A10="Ford")+(B1:B10="June"))

to

=SUMPRODUCT(SIGN((A1:A10="Ford")+(B1:B10="June")))

because Fords in June would get double counted.

Kind regards,
Bernd

 

[Bob Phillips]

Unfortunately, in my host move I lost some files, so this was an old
version. Also it seems my previous host still holds that email even though
they don't have the domain (sic!), so I have had to change it

I have updated the whole page, tidied some sections up, added 3 new sections
on SUMPRODUCT and VBA, Excel 2007, and Performance, and also split it into 2
pages, the discussion and the examples.

 

[Bob Phillips]

I have updated the SUMPRODUCT page, tidied some sections up, added 3 new
sections on SUMPRODUCT and VBA, Excel 2007, and Performance, and also split
it into 2 pages, the discussion and the examples.

 

[Simon Lloyd]

Nice to have you back Bob, i've removed the redirect now from our foru
so they can get straight on your site - however, i'm viewing your sit
on a widescreen laptop (viewing with IE8) and it appears dishevelled
one side bar high up, one missing and all the content way down?, if
view in compatibility mode (IE7) then the side bar is on the left as i
used to be and content in place with just one missing image, still goo
to have that resource back though

I have updated the SUMPRODUCT page, tidied some sections up, added 3 ne
sections on SUMPRODUCT and VBA, Excel 2007, and Performance, and als
spli
it into 2 pages, the discussion and the examples

-
_________________________________
HT

Bo

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[Simon Lloyd]

Sorry Bob side bar is on the RIGHT its on the left in IE8 - note to self
must wear the gloves on the right hands

Nice to have you back Bob, i've removed the redirect now from our forum
so they can get straight on your site - however, i'm viewing your site
on a widescreen laptop (viewing with IE8) and it appears dishevelled,
one side bar high up, one missing and all the content way down?, if i
view in compatibility mode (IE7) then the side bar is on the left as it
used to be and content in place with just one missing image, still good
to have that resource back though

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)

 

[Bob Phillips]

I thought it was women who had spatial issues with left and right <g>.

That problem has been around a while, I have no idea what causes it, it is
valid W3C HTML. I hope my overhaul when I do it will correct the matter.

 

[Simon Lloyd]

Well roll me over and call me Betty big boy!, it does validate for th
most part just 5 minor issues '[Invalid] Markup Validation o
http://www.xldynamic.com/ - W3C Markup Validator
(http://tinyurl.com/ycznc4q

I thought it was women who had spatial issues with left and right <g>

That problem has been around a while, I have no idea what causes it, i
i
valid W3C HTML. I hope my overhaul when I do it will correct th
matter

-
_________________________________
HT

Bo




(http://www.thecodecage.com/forumz/showthread.php?t=137989

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[Bernd P]

Hello Bob,

Hmm, the OR example is ok now but still a little bit misleading
because you can't just add the criteria comparisons for overlapping
criteria. Their sum has to get SIGN()'ed to make it a foolproof OR (or
you might end up double counting overlaps).

Regards,
Bernd

 

[Bob Phillips]

And none of those make any sense to me, all the things it complains of are
there.

--
__________________________________
HTH

Bob

Well roll me over and call me Betty big boy!, it does validate for the
most part just 5 minor issues '[Invalid] Markup Validation of
http://www.xldynamic.com/ - W3C Markup Validator'
(http://tinyurl.com/ycznc4q)

I thought it was women who had spatial issues with left and right <g>.

That problem has been around a while, I have no idea what causes it, it
is
valid W3C HTML. I hope my overhaul when I do it will correct the
matter.

--
__________________________________
HTH

Bob

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.thecodecage.com/forumz/member.php?userid=1
View this thread:
http://www.thecodecage.com/forumz/showthread.php?t=137989

 

[Bob Phillips]

It is not trying to be an example for different ranges, but for the same
range. Therefore as it cannot be both conditions there is no need to avoid
duplicate counting. At this point it is just introducing OR, to add the
further complication of duplications would be too soon IMO. And SIGN is not
the only way to test for duplicates, so it doesn't have to be SIGN.

 

[Bernd P]

Hello Bob,

Ok, let us disagree again.

IMHO your OR example is misleading.

Regards,
Bernd

PS: I am open to learn something more convincing than SIGN to make the
sum of condition checks safe for an OR:
http://sulprobil.com/html/sumproduct.html