trico_excel
New Member
- Joined
- Aug 4, 2007
- Messages
- 16
I've a list.
A B C D
1 Banana 10 Papaya 15
2 Grape 5 Banana 12
3 Apple 12
4 Papaya 13
I want to sort the Column C (and Column D will go too) to this
A B C D
1 Banana 10 Banana 12
2 Grape 5
3 Apple 12
4 Papaya 13 Papaya 15
Remember, the C2 and C3 are empty (so with D2 to D3). The results can be in any Columns, like E-F and so on.
I'm Using Excel 2003.
Many thanks to All....
BR.
A B C D
1 Banana 10 Papaya 15
2 Grape 5 Banana 12
3 Apple 12
4 Papaya 13
I want to sort the Column C (and Column D will go too) to this
A B C D
1 Banana 10 Banana 12
2 Grape 5
3 Apple 12
4 Papaya 13 Papaya 15
Remember, the C2 and C3 are empty (so with D2 to D3). The results can be in any Columns, like E-F and so on.
I'm Using Excel 2003.
Many thanks to All....
BR.