A friend of mine has a spreadsheet in which each record occupies 4 rows and has 2 columns of data followed by a column for each week of the year.
Is it possible to sort the data so that the top row of the 2nd column of each record is in alphabetical order? I have tried to get her to let me put everything in each record on 1 row but she doesn't like that.
Have a 4th column... (which can subsequently be hidden is wished)
I'm going to suppose that the top left of each record starts at A1
In cell D1 put the formula; =B1
in Cell D2 put the formula; =B1
In cell D3 put the formula; =B1
in Cell D4 put the formula; =B1
In cell D5 put the formula; =B5
in Cell D6 put the formula; =B5
In cell D7 put the formula; =B5
in Cell D8 put the formula; =B5
Then select the range D1-D8 and copy it down as far as necessary.
Then you can sort by column D.
Depending on the version of Excel you may/may not have to select the whole range to sort.
In 2010 version, (which I'm using), if just selecting a single column, when sorting, you get prompted to include adjacent cols with data.
It seems to me that the information, like Topsy, has growed and growed.
It might prove simpler to redesign the spread sheet. So that the left hand columns show Name and Forenames. The following columns contain information that can be hidden and then the weekly information in the next 52 columns
Thanks for the thought but I already tried that and it becomes unwieldy because the number of frozen columns takes up too much space.
Simsy's suggestions is basically very simple and I believe it should work. I'm hoping to have the time to try it when I see my friend tomorrow morning. If it does work, I'll mark this thread as resolved.