Search:

Type: Posts; User: gilesgerman; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: VLOOKUP between company names and stock tickers

    All I have is this information Adler Real Estate AG ADLX:GER for each company in one cell
  2. Re: VLOOKUP between company names and stock tickers

    Yes I tried to give a range of examples. I will know the from to so I think what I need is a find and replace within the string for all the different examples for the end part tenprevious cide for...
  3. Re: VLOOKUP between company names and stock tickers

    This works well. There are the odd instances where it doesn't work but it is good enough for what I am trying to do.

    Finally I am also looking to create another column where I can leave the...
  4. Re: VLOOKUP between company names and stock tickers

    The above is actually a bad example. The four below illustrate it much better so please can you look at those. The assumption should be that the information I want is before the ":" but after the...
  5. Re: VLOOKUP between company names and stock tickers

    This helped a lot thanks

    Also is there anyway to get excel to look at the company and extract the shortened version in the cell next to it?
  6. VLOOKUP between company names and stock tickers

    I have a number of company names in an excel spreadsheet like this.


    <colgroup><col></colgroup><tbody>
    Aceto CorpAZJ:BER


    Petra Diamonds LtdPDL:LSE
  7. Data Mining Software for use with excel

    I am trying to get data from a website into excel. I have been on Wikipedia and a number of software has been recommended. I am using a MacBook Pro. My question is simple which piece of software is...
  8. Multiple Table download from the internet to Excel Yahoo Finance Japan

    Dear All,

    I hope you can help me I am trying to download historical share data for share 8088 from yahoo Japan.

    The first page of the table I need is in the following location: -...
Results 1 to 8 of 8