1

I had a previous question with lots of support and it solved my problem. The next issue I have is sorting the data while bringing the information in the corresponding row with it. A link to the previous question I asked, linked here. This is what I need to do:

I need to take any information in here, the Promotions sheet:

enter image description here

and organize it all into here, the Enlisted sheet:

enter image description here

This is the code I have so far that organizes the ranks, but not the corresponding data:

=ARRAYFORMULA(INDEX(SORT({Promotions!A2:A, IF(Promotions!A2:A="", , VLOOKUP(Promotions!A2:A, {Promotions!L1:L, ROW(Promotions!L1:L)}, 2, 0))}, 2, 1), , 1))
  • I need to bring the information from A2:F in the first photo and order it by column A into the second sheet shown in the second photo. In the order, show in the first photo, L1:L – danstyx Mar 22 at 6:13
  • can you share a copy of your sheet? – user0 Mar 22 at 6:15
  • Yup, give me one second. – danstyx Mar 22 at 6:17
0

=ARRAYFORMULA(SUBSTITUTE(SPLIT(INDEX(SORT({TRANSPOSE(QUERY(TRANSPOSE(
 SUBSTITUTE(Promotions!A2:F, " ", "♦")), , 50000)), IF(Promotions!A2:A="", , 
 VLOOKUP(Promotions!A2:A, {INDIRECT("Promotions!L1:L"&COUNTA(Promotions!L1:L)), 
 ROW(INDIRECT("Promotions!L1:L"&COUNTA(Promotions!L1:L)))}, 2, 0))}, 2, 1), , 1)," "),
 "♦", " "))

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.