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

 

[Fluff]

How are you trying to sort the data?
By formula or with the sort option on the data tab?

 

[ginotx]

How are you trying to sort the data?
By formula or with the sort option on the data tab?

I am trying to sort by the Data Sort Tab-Data>Sort>code and plant name.

I have used this method on other sales item categories, but for some reason this file is not working.
Whatever the problem is, it is also affecting following tabs where I use "unique" to narrow down rows of duplicate codes. Unique is not working. I am at the point of deleting the file and starting over because i suspect some sort of corruption in the file.

 

[Fluff]

You cannot use the sort option on the data tab to sort a spill range.
If you need it sorted you will have to use the SORT function.

 

[ginotx]

You cannot use the sort option on the data tab to sort a spill range.
If you need it sorted you will have to use the SORT function.

I believe I understand your response. I think I need to rephrase my answer then.

This is the sort I do before using the "unique" and "sumif" I sort here to do a visual check of all codes and names in the event someone created a new container size that did not conform to the format they should have used. (someone keeps adding #3/#5 rather than just one size). After the sort, I then use another tab for the formulas.

 

[Fluff]

In what way doesn't the sort work?

 

[ginotx]

In what way doesn't the sort work?

it will not sort in any way. The rows stay in the same order as shown.The same three groups stay separated as shown in the data uploaded.

I can not sort it by code or by name so that the same codes or names are together.
I would hope to sort it so that row 6,18 and 33 are all together as an example. They have the same code and name.

 

[Fluff]

Is the data you posted the result of a formula?

 

[ginotx]

Is the data you posted the result of a formula?

No, I cut and pasted from three other tabs of raw data.
I had to add columns to two of the sets of data to separate their unique data from being in the same column as other data from the last set. That is the blank spaces in some of the columns, these are true blanks rather than "Blank if zero" setting.

 

[Fluff]

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.