sorting problem

gsrikanth · #1 02-15-2012, 05:33 AM

whole data in one sheet
1. first column to convert to_number
2. sort by distinct village

zyzzyva57 · #2 02-15-2012, 05:54 PM

Could you be clearer what you mean?

gsrikanth · #3 02-15-2012, 11:14 PM

Quote:

Originally Posted by zyzzyva57

Could you be clearer what you mean?

if i sort first column
second column sorting goes
i need second column sorting with first column
like
1 apple
2 apple
.
.
.
1 banana
2 banana
.
.
.
1 cherry
2 cherry
reference attachment xls file

JBeaucaire · #4 02-15-2012, 11:22 PM

1) Highlight columns A:B
2) Open the Sort Wizard
3) Sort by column A descending

1) Highlight columns A:B
2) Open the Sort Wizard
3) Sort by column B descending

gsrikanth · #5 02-16-2012, 12:30 AM

Quote:

Originally Posted by JBeaucaire

1) Highlight columns A:B
2) Open the Sort Wizard
3) Sort by column A descending

1) Highlight columns A:B
2) Open the Sort Wizard
3) Sort by column B descending

ooooooooooo thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sorting paragraph numbers	CommDude	Excel	1	01-02-2011 04:38 PM
Sorting elements in a row	Riccardo	Excel	2	12-14-2010 10:08 AM
Macro for automatic sorting	Ziggy-R	Excel	13	10-04-2010 06:57 PM
Sorting question	markg2	Excel	4	01-25-2010 03:13 PM
Sorting Outlook TO: field	anakeimai	Outlook	0	09-30-2009 06:15 AM