Confused why sort will not work

[ginotx]

I have cut the following table down to size to show here. I have three different sets of data combined here prior to using a "=unique" code and "sumif" to combine the data onto a new tab. For some reason I am unable to sort this data by code or plant name.

Wholesale Sales Combined from SBI2 working 0304.xlsx
	A	B	C	D	E	F	G	H	I
1	CODE	PLANT NAME	SIZE	# Sold '23 Land	# Sold '23 Whol	Sales # 2022	Sales # 2023	READY	GROWING
2	53046502	Amelanchier 'Autumn Brilliance'	#15 Tree Form	3
3	70004489	Amelanchier 'Autumn Brilliance'	#10 Multi-stem	1
4	55110459	Arctostaphylos uva-ursi 'Massachusetts'	# 1	202
5	53010146	Berberis thunbergii 'Atropurpurea'	# 5	3
6	53110276	Berberis thunbergii 'Crimson Pygmy'	# 3	196
7	53143605	Berberis thunbergii 'Helmond Pillar'	# 3	3
8	53144919	Berberis thunbergii 'Orange Rocket'	# 3	5
9	53010148	Berberis thunbergii 'Rose Glow'	# 5	97
10	53010149	Berberis thunbergii 'Rose Glow'	# 3	14
11	53144734	Berberis Thunbergii Concorde	# 5	158
12	53144883	Buddleia davidii 'Asian Moon'	# 5	130
13	53145405	Buddleia davidii 'Buzz Hot Raspberry'	# 1	6
14	53146436	Buddleia davidii 'Buzz Hot Raspberry'	# 5	17
15	53046502	Amelanchier 'Autumn Brilliance'	#15 Tree Form		25
16	55110459	Arctostaphylos uva-ursi 'Massachusetts'	# 1		21
17	53010146	Berberis thunbergii 'Atropurpurea'	# 5		5
18	53110276	Berberis thunbergii 'Crimson Pygmy'	# 3		86
19	53144919	Berberis thunbergii 'Orange Rocket'	# 3 / # 5		20
20	53010149	Berberis thunbergii 'Rose Glow'	# 3 / # 5		164
21	53144733	Berberis thunbergii Concorde	# 3 / # 5		26
22	53144883	Buddleia davidii 'Asian Moon'	# 5		98
23	53145217	Buddleia davidii 'Asian Moon'	# 1		12
24	53146436	Buddleia davidii 'Buzz Hot Raspberry'	# 5		29
25	53145405	Buddleia davidii 'Buzz Hot Raspberry'	# 1		15
26	53146057	Buddleia davidii 'Buzz Magenta'	# 1		10
27	53046234	Amelanchier 'Autumn Brilliance'	# 7 Multi-stem			17	0	0	0
28	70004970	Amelanchier 'Autumn Brilliance'	# 7 Multi-stem			3	0	0	0
29	70004489	Amelanchier 'Autumn Brilliance'	#10 Multi-stem			29	0	0	0
30	53046502	Amelanchier 'Autumn Brilliance'	#15 Tree Form			57	3	0	0
31	55110459	Arctostaphylos uva-ursi 'Massachusetts'	# 1			620	93	375	0
32	53010146	Berberis thunbergii 'Atropurpurea'	# 5			231	236	0	750
33	53110276	Berberis thunbergii 'Crimson Pygmy'	# 3			840	94	622	272
34	70005166	Berberis thunbergii 'Crimson Pygmy'	2 1/4" Rose Pot			0	0	0	1100
35	53143605	Berberis thunbergii 'Helmond Pillar'	# 3			76	0	35	0
36	70004805	Berberis thunbergii 'Kobold'	# 5			25	0	5	123
37	70004266	Berberis thunbergii 'Kobold'	# 3			68	0	100	0
38	53144919	Berberis thunbergii 'Orange Rocket'	# 3			306	41	321	0
39	53145151	Berberis thunbergii 'Orange Rocket'	# 5			54	0	0	74
40	70005165	Berberis thunbergii 'Orange Rocket'	2 1/4" Rose Pot			0	0	0	120
41	53010148	Berberis thunbergii 'Rose Glow'	# 5			625	8	158	714
42	53010149	Berberis thunbergii 'Rose Glow'	# 3			108	41	158	136
43	53145232	Berberis thunbergii 'Rose Glow'	2 1/4" Rose Pot			0	0	0	750
44	53144733	Berberis thunbergii Concorde	# 3			50	0	254	0
45	53144734	Berberis Thunbergii Concorde	# 5			495	0	0	40
46	53144883	Buddleia davidii 'Asian Moon'	# 5			806	199	155	225
47	53145217	Buddleia davidii 'Asian Moon'	# 1			16	1	0	0
48	53146436	Buddleia davidii 'Buzz Hot Raspberry'	# 5			256	74	177	216
49	53146927	Buddleia davidii 'Buzz Hot Raspberry'	2 1/4" Rose Pot			0	0	100	0
50	53145405	Buddleia davidii 'Buzz Hot Raspberry'	# 1			25	0	0	0
51	53146440	Buddleia davidii 'Buzz Magenta'	# 5			0	0	0	225
52	53146057	Buddleia davidii 'Buzz Magenta'	# 1			38	4	0	0
53	53146058	Buddleia davidii 'Buzz Purple'	# 1			16	0	0	244
54	53146437	Buddleia davidii 'Buzz Sky Blue'	# 5			0	2	0	0
combined raw partial

 

[ginotx]

In that case I can't think of any reason why you can't sort it.
Can you upload the workbook to a share site such as OneDrive, GoogleDrive, DropBox & mark for sharing. Then paste the link your given to the thread.

I just recreated the data and combined on a new file and tabs and had no problem sorting. I can still upload file later if you care to research for your own answer, but no need to waste more of your time. It appears all tabs on this document are unable to be sorted. Something must be corrupted in this file. I Appreciate your help.

 

[Fluff]

Glad it's working & thanks for letting us know.
If your happy to upload the problem file I'll happily have a look at it.

 

[ginotx]

Glad it's working & thanks for letting us know.
If your happy to upload the problem file I'll happily have a look at it.

Honestly, I would rather not waste your time anymore. I believe something was corrupted. I only have to add new data to this file once a year and will just make a note to backup before next years attempt.
Thank you