which returns the ten album titles in the XML. Note: FILTERXML is not available in Excel on the Mac, or in Excel Online. In the example shown cell B5 contains XML data that describes 10 music albums. For each album, there is information about the title, the artist, and the year. To parse this XML, the FILTERXML function is used 3 times in cells D5, E5, and F5 are as follows: In each case, the XPath expression targets a specific element in the XML. For example, in cell D5, the XPath targets the title element with this string: With this XPath expression, FILTERXML returns all 10 album titles. Because this example has been created in Excel 365, which supports dynamic arrays, the results spill into the range D5:D14 automatically.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.