Sorting and Filtering

[HighAndWilder]

I want to produce a list in cell E3 of the values in column C sorted by the values in column B.

I'm almost there but it's missing the value in cell C4 and has an extra zero at the bottom.

I will use this list in the CHOOSECOLS function. as these numbers represent the columns in another sheet.

Thanks

FindARace Entry Data.xlsm
	A	B	C	D	E
1	A	B	C
2	ID
3	Name	2	2		2
4	Race Number	1	3		15
5	Email Address				6
6	Contact Number				7
7	Address	4	6		8
8	Emergency Contact	5	7		0
9	Medical Information	6	8
10	Date of Birth
11	Age
12	Gender
13	Distance
14	Order Number
15	UKA Affiliation Number
16	Club	3	15
Reports

Cell Formulas
Range	Formula
E3:E16	E3	=FILTER(SORTBY(C2:C16,B2:B16,1),C2:C16>0,"")
C3:C16	C3	=IF($B3>0,MATCH($A3,FindARaceCopy!$A$1:$O$1,0),"")
Dynamic array formulas.

 

[Peter_SSs]

Try

=LET(s,SORTBY(C2:C16,B2:B16,1),FILTER(s,s<>""))

 

[Fluff]

Another option

=LET(s,TAKE(SORT(B2:C100),,-1),FILTER(s,s<>""))

 

[HighAndWilder]

Try

=LET(s,SORTBY(C2:C16,B2:B16,1),FILTER(s,s<>""))

That works fine Peter, Thanks. Project nearly finished now.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.