|
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 |
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 |
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 |
| All times are GMT +1. The time now is 07:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com