FILTERXML Function Explained
The FILTERXML Function in Microsoft Excel is used to extract data from an XML string based on an XPath query. It takes two arguments: an XML string and an XPath query. The function returns the value of the specified node or attribute in the XML string.
FILTERXML Function Syntax
FILTERXML(xml, xpath)
- xml: The XML data to filter.
- xpath: The XPath expression used to filter the XML data.