filterxml

  1. A

    Remove the Characters and the Content between Them Using FILTERXML & SUBSTITUTE

    I have a table of input of words such as: Input Result Biology[23], Chemistry, Physics[17], History, [21]Geography[11] Biology, Chemistry, Physics, History, Geography Mathematics,[27] Science (Terminated), [51]English,[36] History,[79] Music[3] Mathematics, Science, English, History...
  2. gheyman

    Filter Formula

    I am watching a YouTube video and its using =Filter to create a Searchable drop down list. But when I try to recreate whats on YouTube It doesn't like "=Filter" the only option is Filterxml which I think is completely different. '=Filter(A:A,Isnumber(search(D1,A:A))"not found")
  3. P

    Pull specific data from API feed

    Hi, I am trying to build a formula that uses some data pulled in from a webservice api. This is the forumual =WEBSERVICE("https://api.coinmarketcap.com/v1/ticker/ethereum/") What i want to do is populate a cell with the current price in USD which is displayed as "price_usd";"343.114" I have...
  4. A

    Weather Information into Excel using Openweather API Filterxml Webservice

    hi Need help with the following; it is clearly beyond me ! I have an API for openweather.org I can Paste the API info into a Browser and get a response back that looks like this; Webinfo...
  5. B

    IFNA not working on FILTERXML in an array function

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top