B
Brotherwarren
Hi folks,
I'm sure the answer to this must be posted somewhere on this group but
I can't find it!
I have a set of data containing exam results from pupils. The pupils'
names are given in column A,
then for each test that they complete there are 5 pieces of
information, starting with the date the test was taken in column B,
then the test score C, grade this gets in D and two other things in E
and F.
Column G contains the date of the next test that the pupils took,
followed by the test score and so on, repeating this pattern for about
8 tests in total.
I'd like to sort these columns so that each block of 5 columns appears
order, sorted by the date that the pupils took the test.
Is there a way of sorting column order by the values of the cells in
those columns, and is it possible to extend this to sort blocks of 5
columns by the values in the first column in each block of 5?
Many thanks for any advice!
TW
I'm sure the answer to this must be posted somewhere on this group but
I can't find it!
I have a set of data containing exam results from pupils. The pupils'
names are given in column A,
then for each test that they complete there are 5 pieces of
information, starting with the date the test was taken in column B,
then the test score C, grade this gets in D and two other things in E
and F.
Column G contains the date of the next test that the pupils took,
followed by the test score and so on, repeating this pattern for about
8 tests in total.
I'd like to sort these columns so that each block of 5 columns appears
order, sorted by the date that the pupils took the test.
Is there a way of sorting column order by the values of the cells in
those columns, and is it possible to extend this to sort blocks of 5
columns by the values in the first column in each block of 5?
Many thanks for any advice!
TW