Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 29
Default Sorting Project that Requires Math Skills

Dear Math People: I have an Excel sheet of 120 pages, with 5 cards on each
page with a total of 600 cards. I am going to Office Max where they will make
a total of 5 cuts. I need to figure out how to sort my cards (they are
numbered 1-600 accordingly) so that when they make the cuts and then stack
the 5 piles one on top of the other, they will be in order 1-600. Any takers?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default Sorting Project that Requires Math Skills

I'm not sure I understand fully - do you mean 120 pages (from one
worksheet) when printed? Do your 5 cards per page appear under each
other, so that you will have a right (or left) margin to crop off, and
then four horizontal cuts to separate the cards?

If so, then you will want to top stack to be numbered 1 to 120, the
second stack 121 to 240, the middle stack 241 to 360, the fourth stack
361 to 480 and the lower stack 481 to 600. So, on page 1 you will want
the cards numbered 1, 121, 241, 361 and 481, and then on your second
(and subsequent) page you will want to increment the numbers from the
previous page.

Hope this helps.

Pete

On Apr 29, 3:01*am, suestew wrote:
Dear Math People: I have an Excel sheet of 120 pages, with 5 cards on each
page with a total of 600 cards. I am going to Office Max where they will make
a total of 5 cuts. I need to figure out how to sort my cards (they are
numbered 1-600 accordingly) so that when they make the cuts and then stack
the 5 piles one on top of the other, they will be in order 1-600. Any takers?


Reply
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 problem- This operation requires... ChrissySher Excel Worksheet Functions 2 May 22nd 07 05:58 PM
how can i improve my skills in excel CmK Excel Worksheet Functions 4 December 17th 06 04:55 PM
Excel skills mbc Excel Discussion (Misc queries) 0 September 19th 06 09:44 PM
Excel Calculator always requires an = before a math function, can be turned off setting? auto Excel Worksheet Functions 8 August 2nd 06 05:50 AM
Basic skills testing Rob Excel Discussion (Misc queries) 0 August 19th 05 08:03 PM


All times are GMT +1. The time now is 08:36 AM.

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

About Us

"It's about Microsoft Excel"