Posted to microsoft.public.excel.worksheet.functions

MAB

Posts: n/a

Sorting

I have a file with 3500+ rows of data that I'd like to sort. However, I have
two blanks rows between each row of valid data. I want to keep each row of
valid data separated by two blank rows as they are now, even after being
sorted.

Can this be done? If so, how do I go about setting it up?

Thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Advice sought: Multiple column sorting	davidm	Excel Worksheet Functions	3	July 29th 05 02:06 PM
Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . .	agc1234	Excel Discussion (Misc queries)	6	May 26th 05 08:02 PM
sorting number in ascending order	Janice Lee via OfficeKB.com	Excel Discussion (Misc queries)	2	April 8th 05 10:31 PM
SORTING question	Rebecca	New Users to Excel	3	February 24th 05 05:35 PM
Adding a KeyID column for sorting	Rebecca	New Users to Excel	3	February 20th 05 07:09 PM

All times are GMT +1. The time now is 05:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us