Sorting at two columns (Advanced Sort doesn't help)

**shashjindal** · 12-13-2011, 09:31 AM

Hi,

I frequently need to sort the data in columns at two levels simultaneously. However, when I sort the data (as shown below), I don't get the desired output.

Data:

Name Age Date
aaa 23 1-Feb-11
aab 22 5-Mar
abc 21 9-Apr
aaa 23 11-Jun
ba 42 5-Jul
aab 22 6-Aug

Desire Output:

Name Age Date
aaa 23 1-Feb-11
aaa 23 11-Jun
aab 22 5-Mar
aab 22 6-Aug
abc 21 9-Apr
ba 42 5-Jul

Here, sorting is done first on Date column (Oldest to Newest) and then on Names ( Similar names clubbed together) and advanced sort doesn't give this output.

Can anyone help me out on this?

**dilipandey** · 12-13-2011, 09:39 AM

Hi Shashjindal,

You can use simple sort option as per below steps:-

Set First sort on Name on Ascending and Second sort on Date on Ascending order and apply the sort.

I have tested this and ouput is same as per your results.

Regards,
DILIPandey

< click on below 'star' if this helps >

**shashjindal** · 12-14-2011, 02:22 AM

Hi DiliPandey,

Thanks for your response.

The priority is to first have the data sorted according to dates and then on the basis of names. This would sort the data on names and then would bring the same names together. This is the idea behind this exercise.

Can you suggest what to be done? Thanks a lot for your time.

**dilipandey** · 12-16-2011, 02:18 AM

Not sure, might be your date are different years as you have shown some dates in dd-mmm-yy and some in dd-mmm.
If possible, please upload a sample file with little more data. Thanks.

Regards,
DILIPandey

< click on below 'star' if this helps>