excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi, can someone please explain how to add the sort inside this formula?
Excel Formula:
=TRANSPOSE(FILTERXML("<x><y>"&SUBSTITUTE(c2,"-","</y><y>")&"</y></x>","//y"))
test | |||||||
---|---|---|---|---|---|---|---|
C | D | E | F | G | |||
2 | 1-4-10-5 | 1 | 4 | 10 | 5 | ||
3 | wanted | 1 | 4 | 5 | 10 | ||
test |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D2:G2 | D2 | =TRANSPOSE(FILTERXML("<x><y>"&SUBSTITUTE(C2,"-","</y><y>")&"</y></x>","//y")) |
Dynamic array formulas. |