#FILTERXML is one of the most powerful functions in excel that was introduced in the Excel 2013 version under the web series function category. Basically, we use it to extract XML text into a separate cell dynamically, now we have a dynamic array in excel 365 or excel 2021 so it goes more powerful and split the text dynamically from a cell to multiple cells. Here in this video, I have explained in detail,
What is FILTERXML?
Why do we use FILTERXML?
How to convert normal text to XML text?
how FILTERXML function extracts the text from a sentence.
Subscribe to RU-vid & Follow on Facebook Page👇
/ exceluniverse
/ exceluniverse.in
Extract Unique List Using Formula👇
• How to Extract Unique ...
Calculate Working Hours in Excel👇
• How to Calculate Worki...
3D Lookup👇
• Excel 3D Formulas - Mo...
Excel MAXIFS and MINIFS Functions👇
• Excel MAX or MIN with ...
Excel MAX and MIN Functions👇
• MAX and MIN Function i...
14 окт 2024