PDA

View Full Version : Exel Spreadsheet



Woody
25-07-2009, 01:29 AM
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.

Sweep
25-07-2009, 09:33 AM
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.

Parry
25-07-2009, 10:39 PM
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

Sweep
26-07-2009, 12:43 AM
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.

kahawai chaser
26-07-2009, 11:37 AM
Advanced filter may help, if you intend to sort/filter any numerical data using a range of data...

Woody
27-07-2009, 12:21 PM
Thanks guys,
Used your method Barry with a few mod's to suit my particular situation.
All fine now.
Cheers