Perhaps you could sort it by day or use a filter to select only the data for
that day.

Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com

"Adent" wrote:


Hi I have daily data for some ten years listed downwards, and I would
now like to know if there is possible to rearrange them so that I can
get all the data for each day alone I.e. one group of just Monday data
and another group and just Tuesday data as one group, all the numbers
are currently listed from A1 to A2000. I only Monday to Friday as my
days
All help is greatly appreciated!!!

If my explanation werent good enough, this is what my data looks
like now
Tuesday 12/31/2002 279,73
Monday 12/30/2002 279,73
Friday 12/27/2002 281,982
Thursday 12/26/2002 278,829
Wednesday 12/25/2002 278,829
Tuesday 12/24/2002 278,829
Monday 12/23/2002 278,829
Friday 12/20/2002 277,477
Thursday 12/19/2002 275,676
Wednesday 12/18/2002 271,171

All the Tuesdays to come fist then the Mondays etc, it is the actual
numbers I want to rearrange.


--
Adent
------------------------------------------------------------------------
Adent's Profile: http://www.excelforum.com/member.php...o&userid=25743
View this thread: http://www.excelforum.com/showthread...hreadid=391539