| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 101726 | 2009-07-24 13:29:00 | Exel Spreadsheet | Woody (710) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 794972 | 2009-07-24 13:29:00 | Office 98. Exel Data Sort. Reasonably large sheet. I wish to sort on 4 columns - Area, Street, Street Number and one other. I go to "Data Sort" and I only get three options for column selection. Any clues how I can extend this to four so I can sort the whole sheet using a four column sort? Thanks for any suggestions. |
Woody (710) | ||
| 794973 | 2009-07-24 21:33:00 | I don't think you can sort on four columns. But you can select all four colums and sort on one of them then select all four columns and sort on the other three. Two step operation but will give the correct result. |
Sweep (90) | ||
| 794974 | 2009-07-25 10:39:00 | Hi Woody, you need to basically fudge it by using a dummy column that concatenates the columns you want. For example, say I have data in A1:H20 and I want to sort by col H then A then B then C. In column I, enter the following formula in cell I2 and copy the foemula downwards... =H2&A2&B2&C2 You can now sort by column I. After sorting you can hide column I. cheers, Graham |
Parry (5696) | ||
| 794975 | 2009-07-25 12:43:00 | Hi Woody, you need to basically fudge it by using a dummy column that concatenates the columns you want. For example, say I have data in A1:H20 and I want to sort by col H then A then B then C. In column I, enter the following formula in cell I2 and copy the foemula downwards... =H2&A2&B2&C2 You can now sort by column I. After sorting you can hide column I. cheers, Graham A more elegant solution I think. Thanks for that. |
Sweep (90) | ||
| 794976 | 2009-07-25 23:37:00 | Advanced filter may help, if you intend to sort/filter any numerical data using a range of data... | kahawai chaser (3545) | ||
| 794977 | 2009-07-27 00:21:00 | Thanks guys, Used your method Barry with a few mod's to suit my particular situation. All fine now. Cheers |
Woody (710) | ||
| 1 | |||||