Sort 2 1-dimension arrays
Actually sort 1st array (Array1) based on values ascending or descending, then change items in Array2 to match order in Array1
Sort can be in Ascending or Descending order.
Not like sortArray, this one involves two arrays, and can decide order
Edit 2021-10-12: Adding ability in v2 to ignore case in sorting strings.
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Bold.codes
Linkedin LoginarrShort, byRef arrSub, Order_1Asc_2Desc
Sort A2 ascending into A3, then re-order items in A1 according to new list
A3 = ArrSort_2Arr(A2, A1, 1)
Sort A2 descending into A4, then re-order items in A1 according to new list
A4 = ArrSort_2Arr(A2, A1, 2)
A3 = ArrSort_2Arr(A2, A1, 1)
Sort A2 descending into A4, then re-order items in A1 according to new list
A4 = ArrSort_2Arr(A2, A1, 2)
Views 5,552
Downloads 1,513
CodeID
DB ID
ANmarAmdeen
702
Revisions
v2.0
Tuesday
October
12
2021