Please try
=FILTERXML("<x><m>"&TEXTJOIN("</m><m>",,Vehicles1:End!B2:B90)&"</m></x>","//m")
insert new sheet of Vehicles# before sheet end
Please try
=FILTERXML("<x><m>"&TEXTJOIN("</m><m>",,Vehicles1:End!B2:B90)&"</m></x>","//m")
insert new sheet of Vehicles# before sheet end
WOW, thank you very much. This works perfectly.
Could I ask you to explain the formula for me? I am not sure what is going on here.
Thank you again for the solution.
Gray
Last edited by AliGW; 03-30-2022 at 11:49 AM. Reason: PLEASE don't quote unnecessarily!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks