Thread: Sorting
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MAB
 
Posts: n/a
Default Sorting

I have a row of data followed by two blank rows, another row of data followed
by two blank rows, and so on for 3500+ rows.

I want to sort lowest to highest, yet keep two blank rows between each row
of data.

I hope I'm describing this ok. :-)

Thanks.

"Pete" wrote:

Do you mean that you want to sort each block of valid data (i.e.
between each set of blank rows), or do you want to treat all data as
part of one big block and sort that? What is it that determines the
break between each block of data?

Pete