I have XML data delivered to cell B3 from a web service. When I extract the data using FILTERXML the cells in the array that go beyond the length of data delivered in the XML display #N/A. If I encase the FILTERXML in an IFNA or 'IF(ISNA...' it still displays #N/A. I am trying to not use VBA in this application.
Here's the function I'm trying to use:
{=IFNA(FILTERXML($B$3,"//ArrayOfInterests/Interests/Item")" ")}
Please help!
Here's the function I'm trying to use:
{=IFNA(FILTERXML($B$3,"//ArrayOfInterests/Interests/Item")" ")}
Please help!
Last edited: