Excel Formula Challenge #2

Today, we have got another excel challenge where we need to get all these values from non continuous into a column. Try your formula and post it in comment box.

Make it even more fun, Join our Excel VBA Online training

More Detail

Download sample file from here

Challenge #2

Have a look at Challenge #1

Join my VBA whatsApp Group to know more

4 replies

IT Chat says:
May 25, 2020 at 9:46 am
Here is the solution
‘=FILTERXML(“”&SUBSTITUTE(TEXTJOIN(“|”,TRUE,d),”|”,””) &””,”//Root/Data”)
Reply
- Sandeep says:
  May 29, 2020 at 3:26 am
  It’s not working can you please share the excel sheet with formula
  Reply
  - IT Chat says:
    May 29, 2020 at 9:47 am
    this will work if you have TEXTJOIN and FILTERXML formula in your excel version.
    Reply
Ram Krishna Sharma says:
October 12, 2018 at 7:45 am
Please share solution,
Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Leave a Reply Cancel reply