Some links on the [Wayback/Archive] FILTERXML function – Microsoft Support.
It is only available on Windows (because of the underlying XPath libraries used, I think it is MSXML), and “only” as of Excel 2013, but still can be useful.
Some links below on FILTERXML and related XPath information so I can more easily find their content back.
Notes:
FILTERXMLonly supports XPath 1.0- The quotes are huge, for one because I don’t use Excel enough to be an expert, but have enough software experience to sometimes want to use complex concepts in Excel. Having all this in one place helps me with that goal.
- You need to ensure your data is either XML in a well-formed document format, or you can translate your data to well-formed XML.
The links and quotes starting with the question that sparked my interest:
The Wiert Corner - irregular stream of stuff 