Sorting Help:large spreadsheet

hey there I am having some sorting issues. I have a very large spreadsheet and i need to make a moving average of it by date. so i have to sort it by date but it looks like this:

___A___________________B_____________C
1 Need to sort by this___Some Value___=avg(b1:b2)
2 Need to sort by this___Some Value
3 Repeat this 2 row pattern many times.
I need to make a moving average of C by date. But it is an average of the b columns, so when i sort it the value changes.

any ideas? long story short i cannot rewrite all the b columns. I think i might have to rewrite all the c columns, as numbers not averages. As in retype the average as a number.

Hi chico1st,

Couldn't you 'Copy & Paste Special Values' (in column C) after you calculate the moving averages for each day? This way when you sort it the next day the sorting won't affect prior averages. unless there is more to it than in your initial post!