Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas for tracking numbers
IS there ANYONE who knows how to make a formula or a process that can make
tracking numbers 4 to a page down not across a cut 1/4 stack ? That means once i cut a pile of 8.5x11 sheets in 4 quarters.. each stack is numericly in order . Because so far i been posting this question in MS Office help ..NOT 1 soul CAN figure this out !! WHAT gives?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas for tracking numbers
Hi James,
Am I interpreting your request correctly in that you want to cut 4 sheets 8.5 x 2.75 from each sheet? If above is correct then if you have 200 full sheets then the top quarter of the first full sheet will be page 1, second quarter page 201, third quarter page 401 and fourth quarter page 601. Therefore the first quarter of each sheet will be consecutive 1 to 200. Second quarter of each sheet will be first quarter number + 200 Third quarter will be first quarter number + (200 x 2) Fourth quarter will be first quarter number + (200 x 3) I cant give you a specific formula which will return all the answers in one formula; only a separate formula for each quarter. Replace 200 in each of the above with the number of full sheets. If I have not provided the answer then perhaps you need to explain in more detail what you require. -- Regards, OssieMac "james" wrote: IS there ANYONE who knows how to make a formula or a process that can make tracking numbers 4 to a page down not across a cut 1/4 stack ? That means once i cut a pile of 8.5x11 sheets in 4 quarters.. each stack is numericly in order . Because so far i been posting this question in MS Office help ..NOT 1 soul CAN figure this out !! WHAT gives?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas for tracking numbers
Yes that wa sok eccept that, it didnt tell me HOW to create that in excel,
something i didnt know. "OssieMac" wrote: Hi James, Am I interpreting your request correctly in that you want to cut 4 sheets 8.5 x 2.75 from each sheet? If above is correct then if you have 200 full sheets then the top quarter of the first full sheet will be page 1, second quarter page 201, third quarter page 401 and fourth quarter page 601. Therefore the first quarter of each sheet will be consecutive 1 to 200. Second quarter of each sheet will be first quarter number + 200 Third quarter will be first quarter number + (200 x 2) Fourth quarter will be first quarter number + (200 x 3) I cant give you a specific formula which will return all the answers in one formula; only a separate formula for each quarter. Replace 200 in each of the above with the number of full sheets. If I have not provided the answer then perhaps you need to explain in more detail what you require. -- Regards, OssieMac "james" wrote: IS there ANYONE who knows how to make a formula or a process that can make tracking numbers 4 to a page down not across a cut 1/4 stack ? That means once i cut a pile of 8.5x11 sheets in 4 quarters.. each stack is numericly in order . Because so far i been posting this question in MS Office help ..NOT 1 soul CAN figure this out !! WHAT gives?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Coralating tracking numbers | Excel Discussion (Misc queries) | |||
Tracking numbers how to | Excel Discussion (Misc queries) | |||
How do I add tracking numbers to excel | Excel Discussion (Misc queries) | |||
How to insert tracking numbers into my webpage for RMA tracking | Excel Discussion (Misc queries) | |||
How do I set up time tracking formulas? | Excel Worksheet Functions |