Sorting rows based on the content of two columns

[madbloke]

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?

 

[Guest]

Hi
I don't understand your sorting order. Why is 1-99 the top most entry?

 

[s_u_resh]

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