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