Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
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:
Hope you can help - thank you.
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.
Last edited:
