• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic Range with OFFSET not working with Dependant Validation

3G

Member
I've seen most websites suggest the INDIRECT() method when it comes to using dependant validation filters. However, can someone explain why the Offset approach doesn't work for the second drop down to create a dynamic range? Do Volatile functions not play well in this format? Or, does it work?

As a side note, the dependant validation (2nd drop down box), had varying numbers of entries in the columns. I wanted to remove the extra blank rows so the window dropped only as long as the column.
 
There is SirJB7. And yes, that did in fact answer my question.

As always, your help is appreciated. I'll send over some Carlsberg....
 
Hi, 3G!
Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.
ReCarlsgardsberg! ;)
 
Thanks Bobhc! Also some great links. Much appreciated. I assume you are a Newcastle fan?
 
3G

I assume you are a Newcastle fan?

You must be joking :p Have you ever heard a Geordie speak :confused:
We may be in the same country and use the same language but when it comes to regional dialect the only person who can understand what Geordie's and monkey hangers are saying is another Geordie......:D



.
 
@b(ut)ob(ut)hc
Hi, old dog!
Good afternoon.
I should read all the below link just to don't feel like E.T. :oops:
And I wish to learn Irish Gaelic...
Regards!

@3G
Hi!
Maybe this help, more indeed being more than "old rare tea" time of five o'clock.
http://www.geordie.org.uk/
Regards!
 
Before you ask.....



"Monkey hanger" is a term by which Hartlepudlians are often known.

According to local folklore, the term originates from an incident in which a monkey was hanged in Hartlepool, England.
During the Napoleonic Wars, a French ship of the type chasse marée was wrecked off the coast of Hartlepool.
The only survivor was a monkey, allegedly wearing a French uniform to provide amusement for the crew.
On finding the monkey, some locals decided to hold an impromptu trial on the beach; since the monkey was unable to answer their questions, and many locals were unaware of what a Frenchman may look like they concluded that the monkey was in fact a French sailor.
Just to make sure, the animal was thus sentenced to death and hanged on the beach.
The vertical part of ships mast he was hung from is still visible on the beach between the Pilot pier and the Heugh.



An alternative theory is put forwards alongside the above on the "This Is Hartlepool" town guide.
It states that; "Then there are some who point to a much darker interpretation of the yarn. They say that the creature that was hanged might not have been a monkey at all; it could have been a young boy. After all, the term powder-monkey was commonly used in those times for the children employed on warships to prime the cannon with gunpowder."


The Monkey Song
The earliest mention of the hanging appears in a popular song, by 19th century comic performer, Ned Corvan, "The Monkey Song":

In former times, mid war an' strife,
The French invasion threatened life,
An' all was armed to the knife,
The Fishermen hung the Monkey O!
The Fishermen wi' courage high,
Seized on the Monkey for a spy,
"Hang him" says yen, says another,"He'll die!"
They did, and they hung the Monkey O!.
They tortor'd the Monkey till loud he did squeak
Says yen, "That's French," says another "it's Greek"
For the Fishermen had got drunky, O!
"He's all ower hair!" sum chap did cry,
E'en up te summic cute an' sly
Wiv a cod's head then they closed an eye,
Afore they hung the Monkey O!



Given that "only after Corvan's appearances in Hartlepool is there strong evidence for the development of the Monkey story", the song seems a plausible origin for the myth.
 
SirJB7 Good evening old friend

The problem is you cannot use the translator unless you can understand what the Geordie is saying in the first place...;)
 
SirJB7

Missed that thread but as usual I enjoyed reading you posts, I think people need a bit of the blood line that runs through us to understand the implied sarcasm.:p
 
Back
Top