Rearranging rows based on sales and text

[SomeGuyHere]

Hello! I'm trying to use VBA to rearrange rows in the data I have. I want to Make sure all the variations of E and F are grouped together below the highest E or F value. Essentially rearranging rows from the original data in columns A and B to the final arrangement in columns D and E. Is this possible to do? Thank you!

 

[JEC]

Do you have an xl2bb table? So that I can copy?
Changing the array to A2:D16 for example is not working?

 

[SomeGuyHere]

Do you have an xl2bb table? So that I can copy?
Changing the array to A2:D16 for example is not working?

Sorry. I've been trying to get that xl2bb add-on working on my work laptop for the past hour. I still can't get it to work. My company probably blocks all add ons.

So changing the array does seem to work for the example I showed you with the letters. Here's another example with different wording and it doesn't sort at all.

 

[JEC]

Maybe:

=LET(z,A2:B17,sp,TEXTSPLIT(INDEX(z,,1)," "),SORTBY(z,XLOOKUP(sp,sp,INDEX(z,,2)),-1))

 

[SomeGuyHere]

Maybe:

=LET(z,A2:B17,sp,TEXTSPLIT(INDEX(z,,1)," "),SORTBY(z,XLOOKUP(sp,sp,INDEX(z,,2)),-1))

That works perfectly! Thank you!

 

[SomeGuyHere]

Maybe:

=LET(z,A2:B17,sp,TEXTSPLIT(INDEX(z,,1)," "),SORTBY(z,XLOOKUP(sp,sp,INDEX(z,,2)),-1))

Hello again. So the data I work with can vary in row count so I want to cast a broad net in the array box. Is there a way to put those zeros in the image from the result of the formula at the bottom instead of the top?

 

[SomeGuyHere]

Hello again. So the data I work with can vary in row count so I want to cast a broad net in the array box. Is there a way to put those zeros in the image from the result of the formula at the bottom instead of the top?

Pretty janky, but I guess this works for me