| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting
It worked perfectly.
Thanks! "Jim Cone" wrote: MAB, Sort the data, then add the blank rows.. After the data is sorted, in an adjacent blank column, insert 3 consecutive sets of identical numbers from 1 to 3500 ( or whatever). Then sort by the numbered column. Sort the following and see what you get... 1 Adams 2 Jones 3 Washington 1 2 3 1 2 3 '------------------- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "MAB" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
| Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . | Excel Discussion (Misc queries) | |||
| sorting number in ascending order | Excel Discussion (Misc queries) | |||
| SORTING question | New Users to Excel | |||
| Adding a KeyID column for sorting | New Users to Excel | |||
Threaded Mode
