Filtering out Data from FORECAST10DAY to obtain specific period /days data using =FILTERXML in Excel

  • 1
  • Question
  • Updated 3 months ago

 I am now able to get the data I was looking for in the Forecast10day. However it has ten days of data. I am not sure how to use =FILTERXLS in excel to capture more specific data . There are ten periods/days of information. If I want to return a specific day, I am not sure how to write the string to filter out only that data. For example, here is my script below to return the high temp, however with this , it grabs the period 1 data, how would I be more specific to return the  period 5 info. I tried various options and it returns a # VALUE! response. I almost there, just need to figure out this last piece of the puzzle.

=FILTERXML(D16,"//high/fahrenheit")

Thank you for any advice.

Mike

Photo of Mike C

Mike C

  • 9 Posts
  • 0 Reply Likes

Posted 3 months ago

  • 1
Photo of Josh

Josh

  • 2 Posts
  • 0 Reply Likes
im having the same issue, have you had any luck?
Photo of Mike C

Mike C

  • 9 Posts
  • 0 Reply Likes
Unfortunately no :(  I would assume others also ran into this same problem. We must be missing something.
Photo of Josh

Josh

  • 2 Posts
  • 0 Reply Likes
ok will keep searching! all I really want is next day forcasat
Photo of Mike C

Mike C

  • 9 Posts
  • 0 Reply Likes

The Data is there, however I cannot figure out how to filter it out of the response.