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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting rows based on the content of two columns
Hi
try the following formula in a helper column (e.g. column C): =IF(B140,1900+B1,2000+B1)*10+A1 copy this formula down and sort with this helper column. "madbloke" wrote: Frank, 1-99 is the top entry as it is document 1 from 1999. Unfortunately, the 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 and 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 -- madbloke ------------------------------------------------------------------------ madbloke's Profile: http://www.excelforum.com/member.php...o&userid=14422 View this thread: http://www.excelforum.com/showthread...hreadid=272021 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting rows based on the content of two columns
It's not possible without the year. 99 is greater than 0, 1, 2, 3, or 4.
On Mon, 25 Oct 2004 05:44:42 -0500, madbloke wrote: Frank, 1-99 is the top entry as it is document 1 from 1999. Unfortunately, the 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 and 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 |
Reply |
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 |