Search results

Hi Jeff Thanks, I'll keep plugging away at it. I enjoy these sorts of challenges, I get a lot out of it. I have just glanced through your explanation above and that explains, for the most part, the formula I am using. Thanks Cheers

Hi All I was working on a method to find the position of the first capital letter starting from the right in the string rather than the end of the first set of numbers. This is as far as I got...

Hi Hui That looks very interesting. I just might register, though I don't think I would fair to well. Cheers Shaun

Hi MrBramme You could try: =VLOOKUP(MID(E2,FIND("Store",E2),7),$A$1:$B$4,2,FALSE) Cheers Shaun

Hi Ballterrier The spreadsheet you have provided a link to only obtains data from Finviz.com ("The data is downloaded from finviz.com into the “Data” sheet, and a filter table is automatically created.") However, I have a spreadsheet which does something similar to what you are asking for...

Hi SirJB7 Thank you, your code worked an absolute treat. Is anything beyond the capabilities of Excel or more importantly the very much appreciated contributors? Cheers Shaun

Hi SirJB7 Welcome back. The link you have posted is appears to be similar to what I am trying to achieve except the web query picks up the relevant information, where as mine does not. Using the page as a reference, if I import the tables, Excel will retrieve the results found in Sheet1...

Hi Nayan Any further thoughts on how this can be done? Cheers Shaun

Hi Dave From Memory you need to select the row below where you would like the "split" then select Window > Freeze panes. I hope this helps Cheers Shaun

Hi Indian I have just had a quick look, but it seems to me you have recovered an empty file. The file size is 0 bytes. I could be wrong, but that is my take on things. Sorry I can not be of further help Cheers Shaun

Hi Narayn Yes, this will be the only site this will be used for. Cheers Shaun

Hi Narayan What you allude to is correct, I would be interested in obtaining that information for all horses, in all races, across all meets. My previous XML query (which you solved - thank you) allows me to build a list of race meets which then allowas me to construct the address above so...

Hi Chandoo Thank you for taking a look at my query. The source can be found at: http://www.risa.com.au/FreeFields/Results.aspx?Key=2013Apr09,VIC,Yarra Valley then selecting view source in your browser I am not sure how to get the source into Excel or Word or wherever for Excel to do...

Hi All I am wondering if it is possible for Excel to obtain two specific pieces of information caontained with HTML source; Delta Whiskey and 7517.png from: <td class='horse'><a class='GreenLink&#39...

Hi Narayan and Glen Thank you both for taking a look at my problem, I very much appreciate it. Narayan: Thank you, it now works perfectly. Glen: That looks to be a really useful add-in. I am just learning about XML stuff and getting that list is one small part of a larger xml grabbing...

Hi All I am trying to import data from an XML webpage/file but I cannot seem to get the code quite right to import the desired information. I wonder if anyone would care to take a look please? The webpage address is http://tatts.com/pagedata/racing/2013/4/5/RaceDay.xml The data I am trying...

Hi Narayank991 Thank you for taking the time to re-code. It is exactly what I was after. So, in theory (well at least in my head) I would run the code which would solve for the interest rate where the guessed_pmt = actual_pmt, where the actual payment is $583.25. Once this was achieved I...

Hi All I have spent quite some time trying to convert: min_rate = 0; max_rate = 100; # Set Maximum and minimum rate while (min_rate < max_rate - 0.0001) { mid_rate = (min_rate + max_rate) / 2; # Divide by 2 to find midpoint J = mid_rate / 1200; # Convert to monthly decimal percentage #...

Thanks Hui Cheers Shaun

Hi All Lets say we prepare a basic XY line chart plotting anything over time in the usual fashion, say average temp per day. Once the chart has been created, is it the possible to work in reverse? If there is an obvious visual upward trend, is there a way that I could somehow draw the trend...

Hi Faseeh Thank you for taking an interest in my problem. A more extensive search of Chandoo lead me to an awesome article titled "Even faster way to compare 2 lists in Excel". This got me 90% of the way and I was able to complete the rest. Cheers Shaun

Hi All I have two worksheets which I am trying to sort and merge. In worksheet 1 I have data from column A to K but in column C I have a unique identifying number which correspondes with worksheet 2 In worksheet 2 I have data from column A to E with the matching unique identifying number...

Hi mahaveer Looking at your spreadsheet, should your profit not be $2,050.00? Perhaps I have missed something also Hui? Sales: 22/04/2012 20 @ $350 = $7,000 Cost of product: 01/04/2012 10 @ $250 = $2,500 20/04/2012 10 @ $300 = $3,000 ------ Profit for transaction $1,500 Sales...

Hi Narayan It is a shame that it has been discontinued, it has some great possibilities. I will still install it and have a play and see if I can't learn something about data analysis and prediction. Hi Hui That looked even more exciting than the time serious addin. I will certainly have a...

Hi All Just wondering if anyone has used Microsoft Research's Time Series Foundation found: http://research.microsoft.com/en-us/downloads/d599b5d2-5a99-4ee5-8c04-c180eb9044d9/ Is it easy to use? I look forward to any comments/thoughts anyone has. Cheers Shaun