View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default Picking every monday from a list of dates

Hi Arne,

One way is to add a helper column and put the numbers 1 to 7 in
the first seven rows, then select all seven cells click on the fill
handle and drag it to the end of your data.

Then you can sort on that column selecting all the 1's, all the 2's etc.

HTH
Martin