Dynamic Sort Formula

[Loume89]

Hello ... Please help!

I used the dynamic sort formula on a table in the web Excel however I only have V.16 on my MAC and it will not work in there.

The table is for a fishing league (it is for a friend) and when they enter their scores in the different matches I want the person with the lowest total score to move to the top of the table automatically and for the rest to follow suit and for their data and scores to move with them. I want this to happen without having to sort every time manually as soon as the new data is added.

Is anybody able to help please?

 

[felixstraube]

How about:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1
2		Name	Total Points								Name	Total Points
3		Name01	8								Name02	3
4		Name02	3								Name10	3
5		Name03	6								Name08	4
6		Name04	8								Name14	5
7		Name05	11								Name03	6
8		Name06	9								Name12	6
9		Name07	10								Name01	8
10		Name08	4								Name04	8
11		Name09	8								Name09	8
12		Name10	3								Name13	8
13		Name11	10								Name16	8
14		Name12	6								Name18	8
15		Name13	8								Name06	9
16		Name14	5								Name19	9
17		Name15	10								Name07	10
18		Name16	8								Name11	10
19		Name17	11								Name15	10
20		Name18	8								Name20	10
21		Name19	9								Name05	11
22		Name20	10								Name17	11
23		Name21	12								Name21	12
24		Name22	13								Name22	13
25		Name23	16								Name25	13
26		Name24	15								Name27	14
27		Name25	13								Name24	15
28		Name26	18								Name23	16
29		Name27	14								Name26	18
Sheet1

Cell Formulas
Range	Formula
K3:K29	K3	=INDEX($B$3:$B$29,MATCH(SMALL($C$3:$C$29+ROW($C$3:$C$29)/1000, ROW()-ROW($K$2)), $C$3:$C$29+ROW($C$3:$C$29)/1000, 0))
L3:L29	L3	=INDEX($C$3:$C$29,MATCH(SMALL($C$3:$C$29+ROW($C$3:$C$29)/1000, ROW()-ROW($K$2)), $C$3:$C$29+ROW($C$3:$C$29)/1000, 0))

 

[Fluff]

Hi & welcome to MrExcel.
Another option.
In L3 copied down

=SMALL($C$3:$C$29,ROWS(L$3:L3))

& in K3 copied down

=INDEX(B:B,AGGREGATE(15,6,ROW($B$3:$B$29)/($C$3:$C$29=L3),COUNTIFS(L$3:L3,L3)))