Here we go....I'm really having trouble finding the words for this one...
I have a number of rows that have data corresponding to a day. For example Monday 21/08/02 $1000, Tuesday 22/08/02 $2000...etc etc
What i want to do is to have a value for each week and not see all the crap that comes in between.
At the moment the rows are being transferred from another spreadsheet, what i want to happen is when they come through i want them to be sorted into weeks starting from the beginning of the current financial year.
So instead of having 5 rows for all the data from Monday to Friday I just have one row for the week beginning (eg) 24/04/02.
This requires sorting the stuff into the date ranges and adding up all the other values.....and i just have no idea where to begin.....
Does this make sense????
Please Help!!!
I have a number of rows that have data corresponding to a day. For example Monday 21/08/02 $1000, Tuesday 22/08/02 $2000...etc etc
What i want to do is to have a value for each week and not see all the crap that comes in between.
At the moment the rows are being transferred from another spreadsheet, what i want to happen is when they come through i want them to be sorted into weeks starting from the beginning of the current financial year.
So instead of having 5 rows for all the data from Monday to Friday I just have one row for the week beginning (eg) 24/04/02.
This requires sorting the stuff into the date ranges and adding up all the other values.....and i just have no idea where to begin.....
Does this make sense????
Please Help!!!