Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting rows based on the content of two columns
Frank, 1-99 is the top entry as it is document 1 from 1999. Unfortunately, th year has to be entered as 99. This is outside of my control :( The more I think about this, the less sure I am that it is possible. Frank Kabel Wrote: Hi I don't understand your sorting order. Why is 1-99 the top most entry? "madbloke" wrote: Can't figure out how to do this. Columns A and C have numbers which equate to document number an year, like this: A C 1 99 3 04 5 02 4 04 and I need to sort them so they are in document and year order, like this: A C 1 99 5 02 3 04 4 04 Any ideas? -- madbloke ------------------------------------------------------------------------ madbloke's Profile http://www.excelforum.com/member.php...o&userid=14422 View this thread http://www.excelforum.com/showthread...hreadid=272021 -- madblok ----------------------------------------------------------------------- madbloke's Profile: http://www.excelforum.com/member.php...fo&userid=1442 View this thread: http://www.excelforum.com/showthread.php?threadid=27202 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting and lining up data into columns based off content | Excel Discussion (Misc queries) | |||
Sorting rows based on the content of two columns | Excel Programming | |||
Delete Rows Based On Content | Excel Programming | |||
Delete Rows Based On Content | Excel Programming | |||
Hiding rows based on cell content | Excel Programming |