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

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

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