Sort 4 columns individually without losing the order in the other 3

[Ironman]

Hi

Row A:D is filtered so I can sort any of those columns.

My issue is that when I sort Column A Largest to Smallest or any other column then the data in the rows doesn't 'stick' with that column and the numbers become nonsensical.

Here's the data:

Book1
	A	B	C	D	E
178	DIST.	AVE TIME	ROUTE #	#RUNS	ROUTE DETAILS
179	2.2	0:27	32	14	Cullingworth Road/Viaduct (up and down)/Halifax Road/Greenside Lane
180	3.0	0:37	29	11	Cullingworth Road/Up viaduct/Down Station Road/Back up/Down viaduct/Halifax Road/Greenside Lane
181	4.2	0:54	33	15	Cullingworth Road/Viaduct/Station Road/Lane Side/Ling Bob/Wilsden Road/Bents Lane/Hallas Bridge
182	4.2	1:03	41	1	Hallas Bridge/Down Bents Lane/Harden Lane/Smithy Lane/Cross Lane/Lee Lane/Sandy Banks/Harden Lane/Bents Lane/Hallas Bridge
183	5.0	1:08	34	2	Cullingworth Road/Viaduct/Station Road/Lane Side/Ling Bob/Haworth Road/Shay Lane/Crack Lane/Main Street/Bents Lane/Hallas Bridge
184	5.3	1:14	35	3	Cullingworth Road/Viaduct/Station Road/Lane Side/Ling Bob/Haworth Road/Shay Lane/Coplowe Lane/Cross Lane/Smithy Lane/Main Street/Bents Lane/Hallas Bridge
185	5.4	1:11	40	2	Cullingworth Road/Shay Lane/Coplowe Lane/Smithy Lane/Bents Lane/Hallas Bridge
186	6.7	1:27	42	3	Cullingworth Road/Shay Lane/Crack Lane/Main Street/Harden Lane/Mill Hill Top/Wilsden Road/Mad Mile/Home
187	7.0	1:35	36	3	Cullingworth Road/Viaduct/Station Road/Lane Side/Ling Bob/Haworth Road/Wilsden Road/Cottingley Road/Lee Lane/Cross Lane/Smithy Lane/Wilsden Road/Bents Lane/Hallas Bridge
188	7.0	1:31	39	1	Cullingworth Road/Viaduct/Ling Bob/Haworth Road/Shay Lane/Coplowe Lane/Smithy Lane/Main Street/Harden Lane/Mill Hill Top/Wilsden Road/Mad Mile/Greenside Lane
189	7.7	1:44	37	4	Cullingworth Road/Viaduct/Station Road/Lane Side/Ling Bob/Haworth Road/Wilsden Road/Cottingley Road/Lee Lane/Cross Lane/Coplowe Lane/Crack Lane/Main Street/Bents Lane/Hallas Bridge
190	9.4	2:13	38	3	Cullingworth Road/Viaduct/Harecroft/Ling Bob/Wilsden Road/Cottingley Road/Lee Lane/Cross Lane/Coplowe Lane/Crack Lane/Main Street/Harden Lane/Wilsden Road/Mad Mile/Home
191	10.4	2:27	14	25	Hallas Br/Down Bents Ln/Up Harden/Smithy/Lee Farm/Black Hills/Golf Course/Beck Foot Ln/Wagon Ln/Up LLC to top of 5-Rise Locks/Back to 3-Rise Locks & over Br/Brown Cow/Main Rd home
192	13.1	3:12	43	1	Hallas Br/Down Bents Ln/Up Harden/Smithy/Lee Farm/Black Hills/Golf Course/Beck Foot Ln/Wagon Ln/Up LLC beyond Duck House to grass chicane/Back to 3-Rise Locks & over Br/Brown Cow/Main Rd home
193	15.3	3:45	44	1	Hallas Br/Down Bents Ln/Up Harden/Smithy/Lee Farm/Black Hills/Golf Course/Beck Foot Ln/Wagon Ln/Up LLC to junct. of Granby Ln (Riddlesden)/Back to 3-Rise Locks & over Br/Brown Cow/Main Rd home
Analysis

Cell Formulas
Range	Formula
B179	=C66
B180	=C47
B181	=C86
B182	=C151
B183	=C94
B184	=C102
B185	=C143
B186	=C159
B187	=C110
B188	=C135
B189	=C119
B190	=C127
B191	=C31
B192	=C167
B193	=C175
D179	=A66
D180	=A47
D181	=A86
D182	=A151
D183	=A94
D184	=A102
D185	=A143
D186	=A159
D187	=A110
D188	=A135
D189	=A119
D190	=A127
D191	=A31
D192	=A167
D193	=A167

Hope you can help - thank you.

 

[mole999]

does this make sense

Excel Workbook
	A	B	C	D	E	F	G
1	178	DIST.	AVE TIME	ROUTE #	#RUNS	ROUTE DETAILS
2	179	2.2	00:27	32	14	Cullingworth Road/Viaduct (up and down)/Halifax Road/Greenside Lane	2.2 0.01875 32 14
3	180	3	00:37	29	11	Cullingworth Road/Up viaduct/Down Station Road/Back up/Down viaduct/Halifax Road/Greenside Lane
4
5					2.2 0.01875 32 14	Cullingworth Road/Viaduct (up and down)/Halifax Road/Greenside Lane
6
7						Cullingworth Road/Viaduct (up and down)/Halifax Road/Greenside Lane
Sheet1

 

[Ironman]

Thanks for your trouble Mole - I'm sorry but I don't see how your suggestion will enable me to sort columns B:E above.

 

[mole999]

as long as the numbers are all sorted together thereby maintaining their individual relationships then the route will align on the unique combination of them from the vlookup

 

[RasGhul]

Referring back to my first post, all I want to do is be able to sort any of the first 4 columns from smallest to largest and largest to smallest. I think the cell links are making this difficult though.

Yes but we may need to change tack to achieve your actual goal. You have many criteria Rank, Date, Time & Pace. Once filtered then you calculate average and you want the hyperlinks to follow any type of list that you set?

Can you clarify please.

 

[Ironman]

Mole - Thanks again, though I don't understand what the value in G2 is doing in E5.

RasGhul - I posted that just so the formulas in the originating cells can be seen. My first post shows the copied results from those cells that I now want to sort. Maybe if those copied formulas were automatically converted to values it would make a difference?

 

[mole999]

G2 shows how to concatenate the values.

E5 is part of a single line VLOOKUP to demonstrate from