Excel Forum

Posted: **Tue Aug 13, 2024 4:13 pm**

Hi there

I need you to figure out sorting issue with excel formula

I attach a template

Needed dynamic array

thx

Posted: **Tue Aug 13, 2024 9:55 pm**

...

G3

=LET(x,E3:E9,DROP(SORT(HSTACK(MID(x,2,SEARCH("-",x)-2)+MID(x,SEARCH("-",x)+1,9)/10^6,x)),,1))

Bigcat9

Bangkok Thailand

Posted: **Wed Aug 14, 2024 7:29 am**

sorting