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
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...
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...
Well this works if it helps anyone....
Sub testwssubset()
Dim vWSsubset As Variant
Dim vws As Variant
Dim ws As Worksheet
vWSsubset = Array("Sheet1", "Sheet2", "Sheet3", "Sheet4")
For Each vws In vWSsubset
For Each ws In ThisWorkbook.Worksheets
If...
OK thanks Narayank991 wow you are fast - Thanks I will try that syntax and play with it on getting to see the names as worksheets and let you know if it works.
Cheers
John
Hi all
I have a large Workbook with about 60 worksheets. But of these I have only 20 or so that have to be updated with new data.
Can I or how can I create an object of these 20 worksheets which I need to define by tab name as the index numbers for these sheets are not in one group. I know...
Hi and many thanks Chandoo, I thought I was going nuts. The formula should work but it doesn't for some reason. I am not getting the days returned I am getting another number that makes no sense. After many frustrating attempts I have given up and gone for the following workaround index/match...
Hi everyone, I have a problem with using SUMPRODUCT and a range of time data (hours) from a report dumped out of our system as CSV, copied into my workbook.
My formula is...
Hi Gert-Jan
http://www.mrexcel.com/pc09.shtml has a Accounts Receivable tool from a Mr Excel Challenge - page down to IOANNIS's winning macro: section. I know it probably won't suit you right now as you need to know a bit about VBA to get it working for you. It also can be slow if the...
mrzoogle
I would think you want to summarise or highlight certain results by ID# and then have a summary to highlight across the 50 ID#s so you can see across this high number of things to manage. You would also want an interactive graph to see trends.
I would leave the data as is in it's...
Hi SuperKrishna
I really like Luke's code and this is an alternative that can work with it.
I faced this problem with a new HP Laptop - HP took up Drive E with HP Recovery software and all my VBA for opening files assumed E for an External HDD which I tend to use for all data. But...