LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,290
Default Need a sorting solution

Glad I was able to help.
Jim Cone


"Rob A"
wrote in message
You are an absolute genius.


"Jim Cone"
wrote in message
I think I got it...
With your data in Excel in a single column say 500 items...
In an adjacent column, fill down numbers from 1 to 500.
This column is to verify that the desired order is achieved.
In another adjacent column fill down from 1 to 125, then
repeat that 3 more times. You will have four consecutive
sets of 1 to 125 in that column.
Sort all three columns by that last column.
Clear the other columns and do your mail merge.
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Sorting Sorting Sorting Skydiver Excel Discussion (Misc queries) 4 June 3rd 06 02:42 PM
Sorting SnobbishJade New Users to Excel 6 April 2nd 06 02:08 AM
Need a sorting solution Patrick Simonds Excel Discussion (Misc queries) 4 March 16th 05 11:38 AM
Generating excel combinations mark4006 Excel Discussion (Misc queries) 2 March 6th 05 04:40 PM
sorting question Brian Excel Discussion (Misc queries) 4 November 28th 04 12:30 PM


All times are GMT +1. The time now is 10:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"