Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting rows based on the content of two columns
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting rows based on the content of two columns
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting rows based on the content of two columns
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 |
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) | |||
Highting rows based on content of cells | Excel Worksheet Functions | |||
Delete Rows Based On Content | Excel Programming | |||
Delete Rows Based On Content | Excel Programming | |||
Hiding rows based on cell content | Excel Programming |