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

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

Dear Sir,

You please convert the year format to "yyyy" or if you have typed yea
as numbers
sort them and use the formula so you will get full year data
Example

=CONCATENATE("20",C1) ' if C1 VALUE IS 04

will give 2004

I hope this will work for you.

Regards
S.Sures

--
s_u_res
-----------------------------------------------------------------------
s_u_resh's Profile: http://www.excelforum.com/member.php...fo&userid=1567
View this thread: http://www.excelforum.com/showthread.php?threadid=27202