VSORT with sorting (Ascending-Descending)

[Ali Kırksekiz]

I did Data-Sort and macro but I can't do VSORT (more function)

I am having trouble getting VSORT to work I have to four columns

Number......Name............Lesson Code.............Mark
256...........Michael XX ..........TAM..................... 56
112...........Zeeman AA.........MAT...................... 78
80.............Adrian PP...........ING....................... 45
657...........Bob FF................COG......................95

Sort ascending Number list/I want to like this

Number......Name............Lesson Code.............Mark
80.............Adrian PP...........ING....................... 45
112...........Zeeman AA.........MAT...................... 78
256...........Michael XX ..........TAM..................... 56
657...........Bob FF................COG......................95

Sort ascending(alphabetical)Name list/I want to like this

Number......Name............Lesson Code.............Mark
80.............Adrian PP...........ING....................... 45
657...........Bob FF................COG......................95
256...........Michael XX ..........TAM..................... 56
112...........Zeeman AA.........MAT...................... 78

Sort ascending (alphabetical)Lesson code list/I want to like this

Number......Name............Lesson Code.............Mark
657...........Bob FF................COG......................95
80.............Adrian PP...........ING....................... 45
112...........Zeeman AA.........MAT...................... 78
256...........Michael XX ..........TAM..................... 56


Thanks for any help

 

[Krishnakumar]

Hi,

Book1
	F	G	H	I
1	Number in ascending order
2	80	Adrian PP	ING	45
3	112	Zeeman AA	MAT	78
4	256	Michael XX	TAM	56
5	657	Bob FF	COG	95
6
7	Name in ascending order
8	80	Adrian PP	ING	45
9	657	Bob FF	COG	95
10	256	Michael XX	TAM	56
11	112	Zeeman AA	MAT	78
12
13	Lesson Code in ascending order
14	657	Bob FF	COG	95
15	80	Adrian PP	ING	45
16	112	Zeeman AA	MAT	78
17	256	Michael XX	TAM	56
Sheet1

Formula in F2 and copied down & across,

=INDEX(VSORT($A$2:$D$5,$A$2:$A$5,1),ROWS($A$2:$A2),COLUMNS($F$1:F$1))

In F8,

=INDEX(VSORT($A$2:$D$5,$B$2:$B$5,1),ROWS($A$8:$A8),COLUMNS($F$1:F$1))

In F14,

=INDEX(VSORT($A$2:$D$5,$C$2:$C$5,1),ROWS($A$8:$A8),COLUMNS($F$1:F$1))

HTH

 

[Ali Kırksekiz]

Good answer .Thanks Kris