+ Reply to Thread
Results 1 to 3 of 3

Get certain data out of dynamic data

  1. #1
    Forum Contributor
    Join Date
    01-17-2011
    Location
    amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    189

    Get certain data out of dynamic data

    If I have the following data in B2:

    ^SP500,"S&P 500","11/7/2011",1247.77,N/A,N/A

    And I want to have only 1247.77 in cell B3 how can I do that.
    It is dynamic data so it is changing a lot. For example it can change to:
    ^SP500,"S&P 500","8/8/2011",1253.21,N/A,1256,39
    Here I also need only 1253.21.

    How is this possible?
    Thanks a lot

  2. #2
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Re: Get certain data out of dynamic data

    I suppose you could use text to columns & then Index to column 4

  3. #3
    Forum Contributor
    Join Date
    01-17-2011
    Location
    amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    189

    Re: Get certain data out of dynamic data

    No but the data changes automatically, so this option does not help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1