Whats expression works to FILTERXML info for each individual period in forecast

  • 1
  • Question
  • Updated 3 weeks ago
Has anyone figured out how to FILTERXML the individual periods info in 10 day forecast within Excel?

For example for day 3...

I've Tried =FILTERXML(A4,"//period.2"), =FILTERXML(A4,"//period/2"), =FILTERXML(A4,"//period//2") and all return invalid results the only thing that works is =FILTERXML(A4,"//period") which is the present day so cant filter out the other forecast days or periods at the moment and there does not seem to be any info out there?

Any help would be much appreciated.
Photo of Ray

Ray

  • 2 Posts
  • 0 Reply Likes

Posted 3 weeks ago

  • 1

Be the first to post a reply!