Results 1 to 4 of 4

Limiting Number of Lookups for XML

Threaded View

fansoffloyd Limiting Number of Lookups... 06-06-2013, 12:46 PM
djapigo Re: Limiting Number of... 06-06-2013, 01:40 PM
fansoffloyd Re: Limiting Number of... 06-07-2013, 10:18 AM
djapigo Re: Limiting Number of... 06-07-2013, 02:22 PM
  1. #3
    Registered User
    Join Date
    05-29-2012
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    31

    Re: Limiting Number of Lookups for XML

    Thank you so much for the reply. It is doing what you said it would but there is another way I need the info to line up:

    When I do =ImportXML(B$1,A$1)

    b1 = Drudgereport.com
    A1 = //tt/b/a

    It automatically populates straight down the row exactly the way I want it autopopulating seperate columns without having to add extra xmlimports. The only problem is it goes on for hundreds of entries all the way down to collumn 150. Do you know how to limit the returns of the xml import to the first 50 returns or the first 50 columns? I would just enter =INDEX(ImportXML(B$1,A$1),2 in each column one by one but googledocs limits you to only 50 xlm imports.

    Thank you so much for baring with me!!!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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