Recent content by Jack

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

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

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

Its all good...

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

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

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

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

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

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

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

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

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

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

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