Sorting Dynamic Data with multiple columns using formulas (Excel 2019) NOT 365

[jstrem75]

Hello,

I would like to re-sort some dynamic data based on the following criteria:

(1) Basic Lv1-Lv4 must come before Advanced Lv1
(2) Basic Lv5 and Advanced Lv1-Lv5 must come before Expert Lv1
(3) Sort shortest time to longest time

I'm not sure how to do it with formulas. Can someone help?

[Richard Buttrey]

Hi,

Does this work:
Create the following Lookup table in say N2:O21


B1 1
B2 2
B3 3
B4 4
A1 5
A2 6
A3 7
A4 8
A5 9
B5 10
L1 11
L2 12
L3 13
L4 14
L5 15
E1 16
E2 17
E3 18
E4 19
E5 20

then in a helper column K, in K2 copied down

Please Login or Register  to view this content.

Then sort on column K

[jstrem75]

Absolutely brilliant! Works!!! Thank you!

[jstrem75]

What about this? I need to extract the data in order from the table and list it. (Leave the blanks out, Only the items with Order Data)

[jstrem75]

Think I got it.

=INDEX(Skill_Data!$A$2:$K$1576,MATCH(SMALL(Skill_Data!$N$2:$N$1576,D3),Skill_Data!$N$2:$N$1576,0),1)