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