sortby returns 0

[james-morris]

When I type =sortby(a2:h2316,g2:g2316,1,h2:h2316,-1) a 0 show up in the cell.

Here's the beginning of the table

1	1	2	3	4	5
aback	a	b	a	c	k	1	0.9308
abase	a	b	a	s	e	1	1.3058
abate	a	b	a	t	e	1	1.3058
abbey	a	b	b	e	y	1	0.0000
abbot	a	b	b	o	t	1	1.8961
abhor	a	b	h	o	r	0	0.8750
abide	a	b	i	d	e	0	0.5000
abled	a	b	l	e	d	0	0.0000
abode	a	b	o	d	e	0	0.9308
abort	a	b	o	r	t	0	1.9519
about	a	b	o	u	t	0	2.8269
above	a	b	o	v	e	0	0.9308
abuse	a	b	u	s	e	0	1.3750
abyss	a	b	y	s	s	1	1.7072
acorn	a	c	o	r	n	0	1.4308

[#2]

@james-morris Copied your sample data and formula. Adjusted only the ranges to match the size of the data and it seems to work as intended. Sort the entire table, first by column G, then by column H.

File attached.