LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default Grouping Large List

All,
I need you to please help me in the below issue:
I have a 25000-line list of items numbered. But inorder to perform an
operation in the softare I use to pull data I need to feed only 1000 numbers
at a time. How do I group the list the way each group will have 1000 lines?
What I am doing right now is that I select the firist cell, shift+drag down
to reach 1000 and name the group with for instance, "A", then go to the next
cell repeat the drill ..."B", and so on so forth. What is the easyest way to
do that? Any Excel functions that you would prompt me with. Thanks in advance.
 
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
List top five results based on age grouping loza Excel Worksheet Functions 2 April 10th 08 03:49 AM
Grouping large amount of data by day-of-week Dan Excel Discussion (Misc queries) 3 January 16th 08 04:34 PM
Producing an automated list from a large list Chuckee Excel Worksheet Functions 0 February 26th 07 04:00 PM
Random Grouping/Fixture List?? Paul Mc Excel Worksheet Functions 0 March 22nd 06 01:31 PM
remove small list from large list Howie J. Excel Discussion (Misc queries) 2 January 4th 06 10:37 PM


All times are GMT +1. The time now is 10:07 AM.

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"