srinivasan05
01-02-2012, 09:58 AM
Hi
I need to sort the data in excel using three columns.The data has to be sorted first by columnA and then by columnB in ascending order and then by Column C.IN ColumnC the first three characters has to be taken into consideration.Suppose we have ABC01 and AB001.Then the third character with the alphabet ie ABC01 should be placed ahead of AB001.
Am able to sort the by coulumnA and ColumnB by Sorting them by ColumnC is bit confusing.
Any ideas for that.
ColumnA ColumnB ColumnC
A 190 ABC01
C 180 AB021
C 180 ABC01
B 180 AD236
E 180 AV002
The output should be
ColumnA ColumnB ColumnC
A 190 ABC01
B 180 AD236
C 180 ABC01
C 180 AB021
E 180 AV002
I need to sort the data in excel using three columns.The data has to be sorted first by columnA and then by columnB in ascending order and then by Column C.IN ColumnC the first three characters has to be taken into consideration.Suppose we have ABC01 and AB001.Then the third character with the alphabet ie ABC01 should be placed ahead of AB001.
Am able to sort the by coulumnA and ColumnB by Sorting them by ColumnC is bit confusing.
Any ideas for that.
ColumnA ColumnB ColumnC
A 190 ABC01
C 180 AB021
C 180 ABC01
B 180 AD236
E 180 AV002
The output should be
ColumnA ColumnB ColumnC
A 190 ABC01
B 180 AD236
C 180 ABC01
C 180 AB021
E 180 AV002