• 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.

Recent content by Jack

  1. Jack

    How do you know Excel is your passion? Or is it?

    Great question Cheryl. But I think the answer is, you just know. Excel or modelling eclipsed any other hobby or interest I ever had. It extends you, it's creative and satisfying. It humbles you when you see how far others have gone. But it drives you to keep going. You become an optimist...
  2. Jack

    VBA documentation

    Just for anyone else looking for 2010 Developer's Documentation as opposed to 2013 here is the link. But note it is not as convenient as the stand alone CHM file for 2013 and has to be extracted to a specific location.... http://www.microsoft.com/en-au/download/confirmation.aspx?id=2451
  3. Jack

    VBA documentation

    Thanks Hui, I searched for the same thing but for 2010 but couldn't find it. If you or anyone else has the link I would be greatful. Cheers John
  4. Jack

    Its all good...

    Its all good...
  5. Jack

    Passing string to web page field (box)

    No worries Marc I was just trying to figure out how you got the URL from what I was seeing but hats off to you, it is great to have the functionality I wanted. Cheers John
  6. Jack

    Passing string to web page field (box)

    OK Marc L appreciate this very much and sorry to put you to more effort but I just want to understand this stuff better. Never had anything to do with XML before and was not even getting a hand hold on the learning curve. On the Test and troubleshoot your Linked CSE page - what is the xml...
  7. Jack

    Passing string to web page field (box)

    @Marc L Thanks very much works perfectly! I must confess I started at the Google CSE help but didn't know enough about how HTML or Java etc worked and so my eyes glazed over and further Googling led me to this other approach. Would you mind cutting and pasting the bit from Help that told you...
  8. Jack

    Passing string to web page field (box)

    Hi all I am trying to pass a search string a user enters to my Google Custom Search Engine (GCSE) https://www.google.com/cse/publicurl?cx=012611895431513734681:xpw195-soo8 . It used to be easy as the search string became part of the URL so I used followhyperlink happily. But these days the...
  9. Jack

    High level data summary using seperate table to define data to HL code [SOLVED]

    Haseeb your formula indeed works perfectly. This is a little gem of a formula with lots of real work applications, thank you very much again, well thought of. Thanks again for your interest Smallman agree and I knew it was a bridge too far to introduce two tables to interrogate within the one...
  10. Jack

    High level data summary using seperate table to define data to HL code [SOLVED]

    Haseeb So sorry to take so long to get back to you - been out all day. I will check this out tomorrow and reply again but it looks like very good to me. Thanks very much for taking the time. Cheers John
  11. Jack

    High level data summary using seperate table to define data to HL code [SOLVED]

    Hi Smallman Thanks for your response and time! Actually the different range size 100 vs 1000 was a typo so sorry for that impression as I know from bitter experience SUMPRODUCT has to be generally symmetrical. If I could I would go back and edit this so it doesn't distract anyone. But...
  12. Jack

    High level data summary using seperate table to define data to HL code [SOLVED]

    Hi everyone, I have a problem I have been trying to solve with SUMPRODUCT but you might have other ideas or come across the same situation. In summary and in simple terms, I want to use an intermediate conversion table to summarise data: data -> prod no -> higher level prod grouping...
  13. Jack

    Find 1st instance of text across multiple columns [SOLVED]

    Hello Shrivallabha yes great formulas, they work well, thanks very much for this. This issue can be closed now. Cheers John
  14. Jack

    Find 1st instance of text across multiple columns [SOLVED]

    All I decided to write a UDF to do this to put myself out of misery...this seems to work and I have it in an Index formula with F35 having the text to look for... =INDEX($F6:$S31,Rowfor_Nth_TextinRange($G6:$S31, F35, 1)-ROW(F6)+1,1) Thanks to Ozgrid for the headstart. Function...
  15. Jack

    Find 1st instance of text across multiple columns [SOLVED]

    Hi everyone This one I think is and I have certainly found to be harder than it sounds. I have a range of data spanning 13 columns G6:S30 with each column representing different jobs on any given day in a business for a roster. Each row is a 1/2 hour time slot. So an employee's initials say...
Top