FINDKEYSBYFILTERA
This function returns keys from an xml variable as an array. It is similar to the FINDKEYSBYFILTER function, which returns the keys as a string, but does not require a separator.
Syntax
FINDKEYSBYFILTERA("XML_properties",filter)
Example
Assume that the XML variable gv_setproperty holds [product] as the key and that Cell C46 contains a FILTER function:
=FINDKEYSBYFILTERA(GlobalVariables.gv_setproperty.Text,C46)
.
When used with the ARRAYTOSTRING function, for example, this example returns [product].