Prev: Countif formula
Next: How to hide a formula and display something else?
From: suestew on 28 Apr 2010 22:01
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?
From: Pete_UK on 29 Apr 2010 08:08
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 <sues...(a)discussions.microsoft.com> 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?

 | 
Pages: 1
Prev: Countif formula
Next: How to hide a formula and display something else?