intheblack
08-13-2008, 09:56 PM
Hi,
I could use some help on how best to approach this.
I have col A which has dates in daily format (eg 19/03/1999) this could range from 100 rows to 12000 rows
Col B has a value for each of those days
How can I;
A) Firstly sort by week, month and year
B) find the lowest and highest value for each week, month and year.
Any suggestions would be appreciated :-)
I could use some help on how best to approach this.
I have col A which has dates in daily format (eg 19/03/1999) this could range from 100 rows to 12000 rows
Col B has a value for each of those days
How can I;
A) Firstly sort by week, month and year
B) find the lowest and highest value for each week, month and year.
Any suggestions would be appreciated :-)