auto sort

[bmuddy2]

good morning fellas
needing a formula to auto sort as values in column H change. i had this before but cant seem to get my old formula to work.

Excel 2012
	G	H	I	J	K
1	data sample			expected results
2	busy	27		material	158
3	fire alarm	1		machine maint	98
4	hot runner	36		robot	60
5	machine maint	98		other	53
6	material	158		hot runner	36
7	nozzell change	6
8	robot	60		and so on.
9	thermolater	9
10	tool problem	31
11	water leak	9
12	other	53
13	aa	0
14	bb	0
15	cc	0
16	dd	0
17	ee	0
18	ff	0
Sheet1

 

[FormR]

Hi, here is one possibility.

Excel 2013
	G	H	I	J	K
1	data sample			expected results
2	busy	27		material	158
3	fire alarm	1		machine maint	98
4	hot runner	36		robot	60
5	machine maint	98		other	53
6	material	158		hot runner	36
7	nozzell change	6		tool problem	31
8	robot	60		busy	27
9	thermolater	9		thermolater	9
10	tool problem	31		water leak	9
11	water leak	9		nozzell change	6
12	other	53		fire alarm	1
13	aa	0		aa	0
14	bb	0		bb	0
15	cc	0		cc	0
16	dd	0		dd	0
17	ee	0		ee	0
18	ff	0		ff	0
Sheet1

Cell Formulas
Range	Formula
J2	=INDEX($G$2:$G$18,AGGREGATE(15,6,ROW($G$2:$G$18)-ROW($G$2)+1/($H$2:$H$18=K2),COUNTIF($K$2:K2,K2)))
K2	=LARGE(H$2:H18,ROWS($K$2:K2))

 

[bmuddy2]

thank you, works perfectly