Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to sort size
Hello, I have a schedule that I need to sort by size. I need a formula in the results field to return the values that I manually entered. Each day is looking at the previous to see what the last size was and determine the closest size to start with, then sort in ascending or descending order for that particular day. Repeat Date Width Length Results 17-Apr-06 9 10 1 18-Apr-06 8 1/4 10 7/8 3 18-Apr-06 8 1/2 10 7/8 2 18-Apr-06 9 10 7/8 1 19-Apr-06 8 1/2 10 7/8 2 19-Apr-06 8 1/4 10 7/8 1 Any help is greatly appreciated. -- kylnn ------------------------------------------------------------------------ kylnn's Profile: http://www.excelforum.com/member.php...o&userid=33449 View this thread: http://www.excelforum.com/showthread...hreadid=532594 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to sort size
Hi kylnn..........
Sorry, but I don't understand exactly what you want........could you give a little more explanation please, and be specific about what result you wish to see..... Thanks, Vaya con Dios, Chuck, CABGx3 "kylnn" wrote: Hello, I have a schedule that I need to sort by size. I need a formula in the results field to return the values that I manually entered. Each day is looking at the previous to see what the last size was and determine the closest size to start with, then sort in ascending or descending order for that particular day. Repeat Date Width Length Results 17-Apr-06 9 10 1 18-Apr-06 8 1/4 10 7/8 3 18-Apr-06 8 1/2 10 7/8 2 18-Apr-06 9 10 7/8 1 19-Apr-06 8 1/2 10 7/8 2 19-Apr-06 8 1/4 10 7/8 1 Any help is greatly appreciated. -- kylnn ------------------------------------------------------------------------ kylnn's Profile: http://www.excelforum.com/member.php...o&userid=33449 View this thread: http://www.excelforum.com/showthread...hreadid=532594 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to sort size
Column A has the date the job is scheduled to run, column B has width of the book, and column C has the length of a book. I am trying to run a machine efficiently by sorting the width and length columns in an order so the machine doesn't have to make a lot of adjustments to produce a book. Sort by the date, then by the size. The only problem is that the last size for that day may be 8x10, so i would like the next day to sort to the closest size for that day. I hope that make sense. -- kylnn ------------------------------------------------------------------------ kylnn's Profile: http://www.excelforum.com/member.php...o&userid=33449 View this thread: http://www.excelforum.com/showthread...hreadid=532594 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to sort size
If you are just wanting to do a custom SORT, with multiple keys, then do Data
Sort and follow the menu to select each key and order.......... hth Vaya con Dios, Chuck, CABGx3 "kylnn" wrote: Column A has the date the job is scheduled to run, column B has width of the book, and column C has the length of a book. I am trying to run a machine efficiently by sorting the width and length columns in an order so the machine doesn't have to make a lot of adjustments to produce a book. Sort by the date, then by the size. The only problem is that the last size for that day may be 8x10, so i would like the next day to sort to the closest size for that day. I hope that make sense. -- kylnn ------------------------------------------------------------------------ kylnn's Profile: http://www.excelforum.com/member.php...o&userid=33449 View this thread: http://www.excelforum.com/showthread...hreadid=532594 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I sort by the value of my formula and not actual formula | Excel Worksheet Functions | |||
Formula to sort names in alphabetical order? | Excel Discussion (Misc queries) | |||
Sum if or some sort of match formula | Excel Worksheet Functions | |||
Preform alphabetical sort without formula in cell changing | Excel Discussion (Misc queries) | |||
Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) |